Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to clarify the doubts Expand / Collapse
Author
Message
Posted Friday, June 28, 2013 3:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
Hi all

1.full backup daily 10 am
2.differential daily backup 6 pm
3.logshipping is running and transactional log backups are genrating at every 10 mins

database is crased in primary server at primary server

how can we recover the database in the secondary server without data loss


Thanks & Regards
NAGA.ROHITKUMAR
Post #1468474
Posted Friday, June 28, 2013 4:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 42,953, Visits: 36,110
With that log backup frequency, you have a data loss of up to 10 minutes, depending on the type of failure of the primary.

If the primary fails entirely and you cannot get to the transaction log of the database, then the best you can do is to restore the last log backup that you have on the secondary and bring it online.
If you can get to the transaction log of the primary database, then you can take a tail-log backup, restore that on the secondary after all other log backups and that will bring it online with 0 data loss.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1468482
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse