Skip to content

Instantly share code, notes, and snippets.

@MichalGrzegorzak

MichalGrzegorzak/restore.sql

Forked from rasmuskl/restore.sql
Created January 14, 2014 06:14
Show Gist options
  • Save MichalGrzegorzak/8413875 to your computer and use it in GitHub Desktop.
Save MichalGrzegorzak/8413875 to your computer and use it in GitHub Desktop.
Download ZIP
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