how to reinitialize log shipping?

  1. Disable the log shipping jobs on both servers.
  2. Back up the database on Server A.
  3. Restore the database with the backup you just created and with norecovery on Server B.
  4. Re-enable the log shipping jobs on both servers.

Tags:

Transaction Log

Related

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio How to optimize very slow SELECT with LEFT JOINs over big tables Does updating a row with the same value actually update the row? Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) Efficient merging (removing duplicates) of arrays How can I check if connection to Sql Server is encrypted? Switching to Simple Recovery - shrinking transaction logs Granting Select access to all tables within a specific Database in MS SQL How to run OPTIMIZE TABLE on a 3-node cluster? Backing up & restoring 10-20 SQL Server databases to a ~synchronous state? Format column length in SSMS output Create hierarchy of multiple levels where each node has a random number of children

Recent Posts