March 16, 2010 at 2:50 pm
Hi, I have a log shipping problem with sql2005. I got an lert about C drive getting full on the secondary server in log shipping pair. Then i found out that all the system and user dbs are on the C drive and none on D (where it should be)
I tried to detach and move db files, attach db. confirm new file location (D:\MSSQL\Data). As soon as i recreate log shipping, both data and log files move back to C: drive (which has limitied space) on the secondary server. Is there a way to change.
PS: When creating log shipping, I chose the first option to let sql server create backup and restore it on secondary server with no recovery. And the default location on primary server for data and log files is D drive.
March 16, 2010 at 3:04 pm
When you requested SQL backup and restore the db's did you specify where they are to be restored to?
March 16, 2010 at 3:17 pm
Just to add to what has been said:
When you restore the secondary logged shipped database, you have to specify the WITH MOVE statement in the restore script (there are check boxes and file path boxes in the SSMS GUI too) to place the files in a different location compared to the primary database.
Gethyn Elliswww.gethynellis.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply