June 26, 2003 at 1:56 am
Hi!
I need to move all log files of all databases (including master, model, msdb, tempdb and distribution) to a new disk. What is the best way to do this?
Thanks
June 26, 2003 at 4:01 am
Take a look here at this KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 it talks about moving databases. Moving logs are done the same way except you list the original position of the data files.
June 26, 2003 at 5:11 am
If you have replication set up it won't let you detach, you have to drop replication first.
Andy
June 26, 2003 at 5:18 am
2Andy Warren:
"If you have replication set up it won't let you detach, you have to drop replication first."
- It won't let me detach all databases or some of them? I have 700+ replications from one databese only + some on other databases. Dropping replications is not a choice... 🙁
June 26, 2003 at 6:42 am
2Andy Warren:
Can I just backup the database that won't detach and restore it with move option?
June 27, 2003 at 1:45 am
We have to move all databases to a new server last month with distribution. The best way i have found was to backup all databases and restored all db on new server in order : distribution and published db, then master and others. If you restore distribution Db after Master you have a error occured because db is in replication system...
June 27, 2003 at 1:48 am
So you can do the same think to restore your database on the new disk with the move option.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply