How to Restore a Database with a SQL Script

Posted by robd on January 17, 2012
SQL

Now you’ve backed up your database and ruined your server, its time to restore it, here’s how:

 

RESTORE FILELISTONLY FROM DISK = '\\Server\Share\databaseName.bak'

WITH PASSWORD = 'SUPERSECRETPASSWORD',

And STATS = 1

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.