mssql_log_shipping_secondary

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		 Previous revision
mssql_log_shipping_secondary [2020/03/10 14:24] – created andonovjmssql_log_shipping_secondary [2020/09/14 14:32] (current) – [Restore] andonovj
Line 69: Line 69:
 </sxh> </sxh>
  
-Nice that for newer version, for example SQL2008 -> SQL2016 we have to use NORECOVERY instead of Standby.+Notice that for newer version, for example SQL2008 -> SQL2016 we have to use NORECOVERY instead of Standby.
 After the backup completes, it will not open the database and the database will appear as "Restoring" After the backup completes, it will not open the database and the database will appear as "Restoring"
  
Line 90: Line 90:
  ,@copy_job_name = N'LSCopy_casino'  ,@copy_job_name = N'LSCopy_casino'
  ,@restore_job_name = N'LSRestore_casino'  ,@restore_job_name = N'LSRestore_casino'
- ,@file_retention_period = 4320+ ,@file_retention_period = 4320     <-------You might want to change that so the transaction logs won't be kept so long
  ,@overwrite = 1  ,@overwrite = 1
  ,@copy_job_id = @LS_Secondary__CopyJobId OUTPUT  ,@copy_job_id = @LS_Secondary__CopyJobId OUTPUT
  • mssql_log_shipping_secondary.1583850279.txt.gz
  • Last modified: 2020/03/10 14:24
  • by andonovj