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

Logshipping to another server with different drive names Expand / Collapse
Author
Message
Posted Wednesday, October 30, 2013 11:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Hello,

We have primary with drive F,L and secondary server with drives D,L.

Data files from F goes to D in secondary and Log file from L goes to L in secondary.

every thing goes smooth untill a new data file is added primary server which will be on F drive , how to get the DB sync happen with the new file created in D drive of secondary server.

Is there a possibility to sync it automatically?



Regards
Durai Nagarajan
Post #1510022
Posted Sunday, November 3, 2013 11:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
this is a common problem that is encountered with log shipping and mirroring when the servers are using disparate drives\paths.

Best way is to


  • disable the LSbackup job

  • run the LSCopy and then the LS restore jobs to ensure all remaining logs have been applied

  • create the new file on primary

  • take a manual differential backup on the primary

  • restore the differential to the secondary with NORECOVERY and the MOVE option specifying the correct drive\path for the new database file

  • enable the LSCopy job




-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1510915
Posted Monday, November 4, 2013 4:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Thanks for you reply

Are there no other alternative to this.



Regards
Durai Nagarajan
Post #1511041
Posted Monday, November 4, 2013 5:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
durai nagarajan (11/4/2013)
Thanks for you reply

Are there no other alternative to this.


You could use a manual log backup instead of a differential and restore WITH NORECOVERY, MOVE.

The easiest option is to ensure the drives and paths are uniform between the instances in the first place


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1511059
Posted Tuesday, November 5, 2013 2:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Do you want to prepare and execute a manual tSQL script?



Regards
Durai Nagarajan
Post #1511399
Posted Tuesday, November 5, 2013 4:56 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Yes, Perry means so.

http://ask.sqlservercentral.com/questions/4065/adding-a-datafile-to-a-log-shipping-primary.html
http://ramaudaya.blogspot.com/2011/09/adding-additional-datafile-to-primary.html
Post #1511436
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse