USEmaster--(Can’tsitinthedatabasewhilstitsbeingrestored!)

GO

ALTERDATABASEMyDatabaseSETSINGLE_USERWITHROLLBACKIMMEDIATE

GO

--RestoreFullBackup

RESTOREDATABASEMyDatabase

FROMDISK=’x:MSSQLBACKUPMyBackupFilename_Full.BAK’

WITH

REPLACE,

NORECOVERY,--UseifmoreT/Logstorecover

--RECOVERY,--UseifNOmoreT/Logstorecover

STATS=10,--Showprogress(every10%)

MOVE’MyDatabase_Data’TO’x:MSSQLDATAMyDatabase.mdf’,

MOVE’MyDatabase_Log’TO’x:MSSQLDATAMyDatabase.ldf’

GO

--OptionalrestoreDifferentialBackup

RESTOREDATABASEMyDatabase

FROMDISK=’x:MSSQLBACKUPMyDatabase_Diff.BAK’

WITH

--RECOVERY--UseifNOmorefiletorecover

NORECOVERY--UseifthereareT/Logstorecover

GO

--OptionalrestoreTransactionLogBackup

RESTOREDATABASEMyDatabase

FROMDISK=’x:MSSQLBACKUPMyDatabase_yyyymmdd_hhmm_Trans.BAK’

WITH

--RECOVERY--UseifNOmoreT/Logstorecover

NORECOVERY--UseifmoreT/Logstorecover

GO

--Setthedatabasereadyforuse(afterallbackupshavebeenrestored)

RESTOREDATABASEMyDatabaseRECOVERY

GO

--Renamelogicalnames(onlyneededifrestoringfromabackupforaDifferentdatabase):

ALTERDATABASEMyDatabase

MODIFYFILE(NAME=’OrigDatabase_Data’,NEWNAME=’MyDatabase_data’)

GO

ALTERDATABASEMyDatabase

MODIFYFILE(NAME=’OrigDatabase_Log’,NEWNAME=’MyDatabase_log’)

GO