How to Restore a Database with a SQL Script | Tech Blog

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

1

2

3

4

5

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

WITH PASSWORD = 'SUPERSECRETPASSWORD',

And STATS = 1

Leave a Reply Cancel reply

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

Copy Protected by Chetan's WP-Copyprotect.