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

LS Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 8:12 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: Saturday, August 9, 2014 2:03 PM
Points: 521, Visits: 2,010
i added one secondary database file on the primarydatabase where the db is configured in logshipping on E drive , how can i restore the file to the secondary server where E drive is not present ? what happens my logshipping
Post #1474149
Posted Tuesday, July 16, 2013 9:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 7:12 AM
Points: 2,255, Visits: 2,717
1. Locate the first LOG backup that has been made on the primary after the database file was added.
2. Restore all LOG backups on the secondary prior to the LOG backup of the previous step.
3. Manually restore the LOG backup from the first step on the secondary and use the WITH MOVE option to place the added file to an existing location

After the above steps the logshipping would continue to work properly.

If the above fails you could also create a differential backup on the primary. Restore this on the secondary using the WITH MOVE option. Remove or move all LOG backups prior to the differential to speed up the logshipping.

Bottom line: you need to restore a back-up on the secondary using the WITH MOVE option to place the added files to an existing location.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1474183
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse