![]() ![]() The DB users and other application users from primary will not be able to login into SQL server or The syslogins and sysusers table in primary and secondary server should be in sync otherwise Restore log DBName from disk = “Local path or Network path” with RECOVERY -> B If you were able to perform only -> C in step1 then go to step 3 If you were able to perform -> A in step 1 then proceed with -> B in step 2 to bring the secondary db ![]() Restore database DBName with Recovery -> C Verify with LSN number which is baced up. Note: Verify the last backup file has been taken, use below T-SQL to get the backups info.Įlse execute the below T-SQL in secondary server to bring the secondary online. Try to backup the Tail end of the transaction log in primary server with NORECOVERY option i.e., perform a transaction log backup if the primary is still accessible.īackup log DBName to disk = “Local path or Network path” with NORECOVERY -> A LOG Shipping Failover (Disaster Recovery) steps ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |