January 19, 2012 at 4:27 am
Hi,
I just wanted to know possible ways acheiving below.
I have log shipping configured. On my secondary server, the database is in RESTORING mode.
There are 5 data file(s) (.mdf and .ndf) associated with it. one of the file is over 900 gigs. The entire db size is over tera-byte.
Now i wanted to move it to a different drive.
Now the problem i cannot take the database offline nor run any alter database command to move the of the files to a different drive.
As of now, what i see only possible way break the log shipping . Take fresh backup of Primary and Restore WITH MOVE option is the only way.
Currently the LS_COPY and LS_Restore jobs are running on secondary server.
I wanted to know is there possible ways so that i can move the file without breaking the log shipping???
Any help would be greatly appreciated.
Thank you.
January 19, 2012 at 4:42 am
As far as I know, you’ll have to break the log shipping.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2012 at 4:50 am
The option which you have selected for that you have only option to reinititae the logshipping.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply