'------------------------------------------------------------------------------ USE MASTER BACKUP DATABASE BDPdv TO DISK = 'C:\SierraBDRbd\Zzz\BDPdv20201201.bak' WITH COPY_ONLY; RESTORE FILELISTONLY FROM DISK = 'C:\SierraBDRbd\Zzz\BDPdv20201201.bak' USE MASTER BACKUP DATABASE BDAct_000999 TO DISK = 'C:\SierraBDRbd\Zzz\BDAct_00099920201201.bak' WITH COPY_ONLY; RESTORE FILELISTONLY FROM DISK = 'C:\SierraBDRbd\Zzz\BDAct_00099920201201.bak' '------------------------------------------------------------------------------ USE MASTER RESTORE DATABASE BDPdv20201201 FROM DISK = 'C:\SierraBDRbd\Zzz\BDPdv20201201.bak' WITH REPLACE, MOVE 'BDPdv' TO 'C:\SierraBDRbd\Zzz\BDPdv20201201_Data.MDF', MOVE 'BDPdv_log' TO 'C:\SierraBDRbd\Zzz\BDPdv20201201_Log.LDF' USE MASTER RESTORE DATABASE BDAct_00099920201201 FROM DISK = 'C:\SierraBDRbd\Zzz\BDAct_00099920201201.bak' WITH REPLACE, MOVE 'BDAct_000999' TO 'C:\SierraBDRbd\Zzz\BDAct_00099920201201_Data.MDF', MOVE 'BDAct_000999_log' TO 'C:\SierraBDRbd\Zzz\BDAct_00099920201201_Log.LDF' '------------------------------------------------------------------------------ USE MASTER ALTER DATABASE BDPdv20201201 SET MULTI_USER WITH ROLLBACK IMMEDIATE; '------------------------------------------------------------------------------