Skip to content

Instantly share code, notes, and snippets.

@rasmuskl

rasmuskl/restore.sql

Created December 15, 2011 21:08
Show Gist options
  • Save rasmuskl/1482889 to your computer and use it in GitHub Desktop.
Save rasmuskl/1482889 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server: Restore + Restore incremental
Raw
restore.sql
ALTER DATABASE [AspectoWeb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [AspectoWeb]
FROM DISK = N'C:\Users\RasmusKL\Desktop\www.aspectoweb.com_backup_2011_12_15_030005_0285276\www.aspectoweb.com_backup_2011_12_14_031114_3950159.wbak'
WITH NORECOVERY, REPLACE
RESTORE DATABASE [AspectoWeb]
FROM DISK = N'C:\Users\RasmusKL\Desktop\www.aspectoweb.com_backup_2011_12_15_030005_0285276\www.aspectoweb.com_backup_2011_12_15_030005_0285276.bak'
WITH RECOVERY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment