Activity overview
Latest activity by fidunton
The script worked well. Thx.
I did change NORECOVERY to RECOVERY so that the DB is left in an operational state:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [testDiff2] FROM DISK = [C:MSSQLBackup*.sqb] SOURCE = [testDiff1] LATEST_ALL WITH PASSWORD = [], RECOVERY, MOVE [testDiff1] TO [F:Microsoft SQL ServerMSSQL11.MSSQLSERVERMSSQLData estDiff2.mdf],
MOVE [testDiff1_log] TO [F:Microsoft SQL ServerMSSQL11.MSSQLSERVERMSSQLData estDiff2_log.ldf], ORPHAN_CHECK"'
Thank you again. / comments
The script worked well. Thx.
I did change NORECOVERY to RECOVERY so that the DB is left in an operational state:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [testDiff2] FROM DISK = [C:MSSQLBa...
Thank you - I will give this a try. Thanks again! / comments
Thank you - I will give this a try. Thanks again!
This seemed to work well:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [testDiff2] FROM DISK = ''C:MSSQLBackupFULL_(local)_testDiff1_20161117_150411.sqb''
WITH PASSWORD = '''', NORECOVERY,
MOVE ''testDiff1'' TO ''F:Microsoft SQL ServerMSSQL11.MSSQLSERVERMSSQLData estDiff2.mdf'',
MOVE ''testDiff1_log'' TO ''F:Microsoft SQL ServerMSSQL11.MSSQLSERVERMSSQLData estDiff2_log.ldf''"'
GO
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [testDiff2] FROM DISK = ''C:MSSQLBackupDIFF_(local)_testDiff1_20161117_150802.sqb''
WITH PASSWORD = '''', RECOVERY, ORPHAN_CHECK"'
GO / comments
This seemed to work well:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [testDiff2] FROM DISK = ''C:MSSQLBackupFULL_(local)_testDiff1_20161117_150411.sqb''
WITH PASSWORD = '''', NORECOVERY,
MOV...
Script to Restore Diffential Backup...
Hello -
I have a scripting question for Restore Diffential Backups....
If I have a backup set consisting of 1 full backup and 2 differential backs like this:
FULL_BARNEY_20161115_090000.SQB
DIFF_BA...