mssql_log_shipping_secondary

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
mssql_log_shipping_secondary [2020/03/10 15:52] 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"
  
  • mssql_log_shipping_secondary.1583855570.txt.gz
  • Last modified: 2020/03/10 15:52
  • by andonovj