sqlserver-recovery.sql

RESTORE FILELISTONLY FROM DISK='c:\cygwin64\home\Administrator\SL_Demo_IL2.bak'
RESTORE DATABASE schoollogic FROM DISK =
'c:\cygwin64\home\Administrator\SL_Demo_IL2.bak' WITH RECOVERY,
MOVE 'patsdata' to 'c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\school-logic.mdf',
MOVE 'patsdata_log' to 'c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\school-logic.ldf'
GO

CREATE LOGIN schoollogic WITH PASSWORD = 'schoollogic', CHECK_POLICY = off
GO

CREATE USER schoollogic FROM LOGIN schoollogic
GO

EXEC sp_addrolemember 'db_owner', 'schoollogic'
GO

ALTER AUTHORIZATION on database::schoollogic to schoollogic