Contents

use master;
go
print "Restore dev db"
go
IF ( EXISTs (SELECT name FROM master.dbo.sysdatabases WHERE name = '$(DB_NAME)2Dev'))
 drop DATABASE $(DB_NAME)2Dev
go
create DATABASE $(DB_NAME)2Dev
go
ALTER DATABASE $(DB_NAME)2Dev
SET SINGLE_USER WITH
ROLLBACK AFTER 5 --this will give your current connections 60 seconds to complete
go
RESTORE DATABASE $(DB_NAME)2Dev FROM  DISK = '/root/backups/$(DB_NAME)2Dev.bak'
WITH  REPLACE;
GO
ALTER DATABASE $(DB_NAME)2Dev SET MULTI_USER
GO

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
container-backup-0.1.0	scripts/mssql/restore_aegean2dev.sql