![]() ![]() RECONFIGURE GOĮxecute the query, and the feature will be enabled.Ģ. EXEC sp_configure 'xp_cmdshell', 1 GO - To update the currently configured value for this feature. To allow advanced options to be changed.ĮXEC sp_configure 'show advanced options', 1 GO - To update the currently configured value for advanced options. Click New Query and enter the following command: But before that, please connect to the instance and enable xp_cmdshell.ġ. You could use a script to restore multiple databases in SQL Server from a folder. Restore multiple databases from bak files using xp_cmdshell If you want to do it more flexibly, there's also an easy alternative with GUI. Generally speaking, you can use a valid T-SQL script to restore multiple databases in one go, but only if the backup files are named exactly after corresponding databases and have no additional info like date/time. If you backed up multiple databases to multiple bak files, can you to restore them all at once? It is regrettable that SSMS GUI only supports restoring one database at a time. Under this paradigm, e-waste would be greatly reduced, maintenance time would also be reduced, there would be no need to "sync" anything since there only would need to be one copy of the data (plus backups, of course), and best of all, it would allow people to travel light, only ever having to carry a small storage device.Can you restore multiple SQL databases at once Terminals and every piece of hardware would provide their own drivers upon being plugged in, hence ensuring true plug-and-play operation, everywhere. This would lead to a data-centric society where computers would merely be viewed as tools or terminals to access our data. No need to install or configure anything since everything, including software registration info, would reside on the portable storage device. Users would be able to unplug their storage device from one terminal, plug it into another, power up and continue exactly where they left off. The device can be docked into any compatible terminal (essentially a computer minus user storage) to gain access to the data and programs. I often fantasize about a society where people carry around a small storage devices containing all the users data, programs and settings. ![]() Using removable storage has been my solution for quite a while and it works well, together with Sandboxie to make certain apps portable (works with 90% of apps including commercial software). I'm leaning towards a 256GB microSD card which I can use on any computer without having to sync anything, and use Bvckup2 for running regular backups. May 18, 2017I've just given Syncthing a very good go, and while it does its job, it does it too slow. The downside of this app is that, due to my limited coding skills, only performs regular whole file copy (vs atomic copy). I use this to back up application settings so I can restore them later. I actually wrote a very basic application using Autohotkey to backup files, folders and registry key. I would love to see some sort of recallable backup job sets (as I mentioned in my earlier post) because you don't always need to backup everything.Īnother thing that may be useful would be the ability to backup registry keys. Even if I end up using something else for syncing, I think it will still have its place as a backup tool. What really impresses me about Bvckup 2 is its efficiency and clean interface. Also I'm not sure how trying to sync a file that's currently being access would pan out, shadow copy may take care of this but the final commit is still being postponed anyway. These two tools serve different purposes and I don't think either does what I want. One other advantage of Bvckup 2 is that it can sync two folders on the same system, whereas Syncthing requires the two folders to be on separate systems. Furthermore, it seems Syncthing needs to rescan every file each time, whereas Bvckup 2 appears to be more efficient. With Syncthing, an unintended file deletion would be propagated to my all devices without my knowledge. If the two machines are physically together I would have network access and would just get to my files over LAN. I'm usually only ever using one machine at a time. There are times when I just don't want my system's resources to be consumed syncing files. I don't need the two machines to be in perfect sync immediately, the whole time. I've considered Syncthing but I'm not convinced it's what I want. ![]() ![]() What I'm trying to achieve is sync two machines. But I hear what you say about using two-way sync software. Wouldn't that require more than just a couple of manual jobs? It's not just a single folder but several. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |