July 4, 2009 at 5:27 am
Dear,
I have a sql server 2005 production database(600 GB) that has 5 data files and 2 ldf files. Data files are placed in 5 different drives(D,E,F,G,H) and log Files are placed in two different drives(I,J). I have one stand by server, which has only 3 drives available for the database. Is it possible to configure logshipping between these two servers. if yes, please let me know . Or we should have the same directory structure to configure logshipping? please help me.
Thanks,
sathya
July 4, 2009 at 5:34 am
Thayalan (7/4/2009)
Dear,I have a sql server 2005 production database(600 GB) that has 5 data files and 2 ldf files. Data files are placed in 5 different drives(D,E,F,G,H) and log Files are placed in two different drives(I,J). I have one stand by server, which has only 3 drives available for the database. Is it possible to configure logshipping between these two servers. if yes, please let me know . Or we should have the same directory structure to configure logshipping? please help me.
Thanks,
sathya
While restoring the full backup on secondary, use WITH MOVE clause to accomodate the data files in available 3 drives. Once the full backup is restored, you can continue with setting up of log shipping. If, however, at a later stage, you add a datafile on a drive which is not available in secondary, it'd fail. In such a case, u'll need to setup ur log shipping again moving the files in available drives.
July 4, 2009 at 6:33 am
Thanks for your immediate response.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply