October 28, 2008 at 9:08 am
Hello,
We have Log shipping setup and working fine. However, now we are really closed to running out of space on the drive that the datafiles are located. We have another drive that have lots of disk space. I am wondering if there is a way to change the location of the data files (mdf files) of the standby database without having to do the whole restore of the database again? or with out breaking the exists log shipping configuration?
I am greatly appreciative for any suggestion.
Thanks!
October 28, 2008 at 9:22 am
You could detach and attach, but I suspect you'll need to alter the log shipping jobs at some point. The log restores should pick up, but not sure how that works with an attach.
The restore commands have a WITH MOVE clause, which you might need. I don't think that will affect log restores.
October 28, 2008 at 11:13 am
I can detach but I can not attach. Encountered error: I cannot attach a database that is being restored.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply