This topic explains the log shipping if the primary database is suspected or corrupted and how you can convert the secondary database into primary database.
To recover a database without restoring (to be done in the master data base)
Execute the RESTORE DATABASE statement, specifying:
/* To recover a database without restoring (to be done in the master data base) Execute the RESTORE DATABASE statement, specifying: The name of the database to be recovered The RECOVERY clause Example For example, you can recover the database, AdventureWorks2008R2, as in a restore operation without restoring data*/ -- Restore database using WITH RECOVERY. RESTORE DATABASE AdventureWorks2008R2 WITH RECOVERY
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
6,822 reads
This article describes the requirements to log ship databases between workgroup computers
2012-01-30
5,175 reads
In this article you will see the detailed steps needed to implement the log shipping for large databases.
2011-09-23
2,889 reads
You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, "we need your help." We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
2010-08-05
3,477 reads
Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.
2010-07-01
5,793 reads
