Skip to content

Instantly share code, notes, and snippets.

@petros

petros/RestoreMSSQLDbWithANewName.sql

Created June 17, 2009 09:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save petros/131163 to your computer and use it in GitHub Desktop.
Save petros/131163 to your computer and use it in GitHub Desktop.
Download ZIP
Restore an MSSQL backup to a different database name
Raw
RestoreMSSQLDbWithANewName.sql
RESTORE DATABASE MyNewDB
FROM DISK = 'D:\MyDB.bak'
WITH
MOVE 'MyDB_Data' TO 'C:\MSSQL\Data\MyNewDB_Data.MDF',
MOVE 'MyDB_Log' TO 'C:\MSSQL\Data\MyNewDB_Log.LDF',
REPLACE
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment