Skip to content

Instantly share code, notes, and snippets.

@regisbsb

regisbsb/gist:014de81a99ea8364d37f

Created July 30, 2014 13:36
Show Gist options
  • Save regisbsb/014de81a99ea8364d37f to your computer and use it in GitHub Desktop.
Save regisbsb/014de81a99ea8364d37f to your computer and use it in GitHub Desktop.
Download ZIP
Restore database
Raw
gistfile1.sql
RESTORE FILELISTONLY
--RESTORE DATABASE test
FROM DISK = 'C:\Users\RegisBenedito\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\LocalSuite\pa_1000ingressos_backup_2014_05_20_040001_9459999.bak'
--WITH MOVE 'pa_1000ingressos.Data' TO 'C:\Users\RegisBenedito\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\LocalSuite\pa_1000ingressos.mdf',
--MOVE 'pa_1000ingressos.Log' TO 'C:\Users\RegisBenedito\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\LocalSuite\pa_1000ingressos.ldf',
--REPLACE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment