Move Transaction Log in SQL 2000

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 in SQL 2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-04 : 13:59:06

Tom writes "How can I move a transaction log from drive D: to drive C: while leaving the database on drive D:?"

chadmat
The Chadinator

1974 Posts

Posted - 2002-03-04 : 14:47:08

See sp_detach_db and sp_attach_db in BOL.

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources