Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/Restore db backup (MSSQL)

Created January 13, 2020 19:02
Show Gist options
  • Save arekgotfryd/33e062dd28e5c1b77610666700952c2d to your computer and use it in GitHub Desktop.
Save arekgotfryd/33e062dd28e5c1b77610666700952c2d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Restore db backup (MSSQL)
RESTORE DATABASE dbname FROM DISK = 'C:\whatever\dbname.bak'
WITH MOVE 'dbname_data' TO 'C:\...\dbname.mdf',
MOVE 'dbname_log' TO 'C:\...\dbname.ldf';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment