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

Another doubt in the testing case i got Expand / Collapse
Author
Message
Posted Friday, June 28, 2013 3:31 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

In primary server
1.taken full backup daily
2.taken differential backup
3.taken transactional log backup

4.logshipping is running and transactional log backups are genrating at every 10 mins

in secondary server how can we restore transactional log manually without the data loss


Thanks & Regards
NAGA.ROHITKUMAR
Post #1468476
Posted Friday, June 28, 2013 3:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:50 AM
Points: 2,262, Visits: 2,725
Restore the last full and differential backup from primary on secundary and leave the database in NORECOVERY or STANDBY. Restore each log backup on secundary after this is created on the primary, still leaving the database in NORECOVERY or STANDBY. In case of disaster create a TAIL LOG backup on primary and restore this on the secundary. Set the database on secundary to RECOVERY if the secundary needs to serve the application because the primary is crashed.
The restore of the LOG backups can be setup as an automated process. This is preferred above a manual approach.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1468479
Posted Friday, June 28, 2013 4:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:50 AM
Points: 2,262, Visits: 2,725
Looks like the original poster has made a double post, see http://www.sqlservercentral.com/Forums/Topic1468474-384-1.aspx

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1468486
Posted Friday, June 28, 2013 4:26 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
This is different post iTs for Testing in T& server to get correct idea

Thanks & Regards
NAGA.ROHITKUMAR
Post #1468489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse