December 22, 2008 at 9:03 am
Consider this scenario: There is a primary server at location A. Log shipping is configured to send logs to locations B and C. There are two servers receiving the logs at location C. One of those two servers' standby database gets corrupted.
Is there a way to re-synchronize the log shipping in the failed database with the other server at location C or is the only way to restart log shipping to use the backup / restore method from the primary server at location A?
I was wondering if some form of a detach / re-attach would work from the other log shipped standby server at C.
Thanks
- John
December 22, 2008 at 9:28 am
John (12/22/2008)
I was wondering if some form of a detach / re-attach would work from the other log shipped standby server at C.
Unfortunately not.
If you try to detach an in recovery database, you will get an error:
Msg 947, Level 16, State 1, Line 1
Error while closing database 'TestingAttach'. Check for previous additional errors and retry the operation.
Despite the error, the detach will succeed. However when you try to reattach the database, it will fail.
Msg 1824, Level 16, State 1, Line 2
Cannot attach a database that was being restored.
SQL 2008 won't allow the in-recovery database to be detached
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2008 at 5:21 pm
I don't think there's a way to reset the LSNs and as Gail mentioned, you can't detach/attach.
My guess is only another full backup will work.
December 24, 2008 at 1:34 am
I agree with Steve, We had faced the same issue,
We took a full backup and setup the log shipping once again
"More Green More Oxygen !! Plant a tree today"
December 26, 2008 at 2:35 am
December 27, 2008 at 2:55 am
Paresh Prajapati (12/26/2008)
Take transaction log backup of database and apply on that server with recovery.
How's that going to help with creating a second copy of an in-recovery database without breaking log shipping?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply