Skip to content

Instantly share code, notes, and snippets.

@andreasbotsikas

andreasbotsikas/Restore SQL db to new server

Created November 25, 2013 20:36
Show Gist options
  • Save andreasbotsikas/7648426 to your computer and use it in GitHub Desktop.
Save andreasbotsikas/7648426 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Restore SQL db to new server
Restore database nameOfDbInTheBackupFile
FROM DISK = 'C:\dbFullBackup.bak'
with move 'mdf_file_name' to 'c:\db\mdf_file_name.mdf',
move 'ldf_file_name' to 'c:\db\ldf_file_name.LDF'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment