Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted

Freeware One-Click SQL Restore associates with .bak files and claims to restore in a couple of clicks

share|improve this answer
add comment

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.