April 23, 2003 at 7:11 am
Hi!
Have a MS SQL2000 Server and ~10 databases on it. Some databases use transactional replication. I'd like to move all log files for all databases to another disk. How can I do this?
Thanx.
April 23, 2003 at 7:15 am
Detach the databases, move the physical files to the location that you desire and then attach the databases with the proper path specified. See sp_detach_db and sp_attach_db in Books On Line for details.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 7:34 am
Is it possible to do this without detaching the databases?
April 23, 2003 at 8:05 am
Here is a good knowledge article on the subject. Of course they say use detach/attach. You can do a database backup and restore with move option as well.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply