Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Move Transaction Log -- Easy One...Help!!!

Author  Topic 

gogo7188
Starting Member

12 Posts

Posted - 2003-06-03 : 07:00:09
This should be a real easy one for all you gurus out there. Currently my primary transaction log sits here: c:\tlogs\tlogname.ldf
and I need to move it to another drive so that it looks like this: h:\tlogs\tlogname.ldf

How can I do this without corrupting the database? I goofed and put my TLOGS on my OS drive and I need to move them to another location. Please help. Thanks, Chad

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-06-03 : 07:50:20
INF: Moving SQL Server Databases to a New Location with Detach/Attach

Jay White
{0}
Go to Top of Page
   

- Advertisement -