I have to restore various SQL server databases several times a day (for development purposes). In SSMS interface it takes forever and it is even longer to type RESTORE DATABASE command with all it's paths. Ideally I would like to double-click a BAK file right in Windows Explorer and run something to restore it. How can I do it?
Asked
Active
Viewed 358 times
3 Answers
2
Freeware One-Click SQL Restore associates with .bak files and claims to restore in a couple of clicks
Mike
- 136
- 3
1
We've simply built scripts which take inputs as to the name of the backup file, the type of backup, etc. and use those globally. Another option is to look at a tool like Red Gate's SQL Backup. Backups and restores through a few mouse clicks and it'll even script what it's doing.
K. Brian Kelley
- 9,034
- 32
- 33
0
It's quite common to write the backup database command, and then put that into a SQL Server job - which can be executed either on demand or on schedule. That works perfectly for many when the restore point is the same each time.
Have you thought about using database snapshots before you do your work? It allows you to rollback to when the snapshot was taken very very quickly indeed.
The only things to be aware of with snapshots are that there is a small performance overhead, and that it's in the Enterprise/developer editions. That'll be generally fine in development, but the edition will let you develop using features that aren't in Standard edition.
Peter Schofield
- 1,639
- 9
- 11