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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-18 : 09:27:25
|
| Shamim writes "Hi:I would like to move database transaction log files into a different drive and remove from the present location. How can I do that. Any help in this matter is highly appreciated.Thanks!Shamim" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-18 : 10:05:01
|
| Look in Books Online under the "ALTER DATABASE" command. I think you'll have to use ADD LOG FILE to add the new log you want, and then use a separate REMOVE FILE to drop the old log file.MAKE SURE YOU PERFORM A FULL DATABASE BACKUP BEFORE YOU ATTEMPT THIS! |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-18 : 10:57:00
|
| If you add a second log file, SQL Server will still see your original log file as "primary" log file (and therefore will not let you remove it). AFAIK, there is no way to turn your new file into a "primary". So I don't believe Rob's suggestion will work. What you could do, is detach your database using sp_detach_db stored procedure, copy your log file to a new location, and attach the database back using sp_attach_db.Edited by - izaltsman on 02/18/2002 11:00:09 |
|
|
|
|
|
|
move database transaction log file