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 |
|
edeleon
Starting Member
3 Posts |
 Posted - 2006-09-24 : 23:24:23
|
| Does the sql log file have to be in the same location as the DB or can the logfile be placed in another drive. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-24 : 23:56:06
|
not necessary. Infact, if possible, place the log file on separate physical disk
KH |
 |
|
|
edeleon
Starting Member
3 Posts |
Posted - 2006-09-25 : 11:51:44
|
| I have tried to place the log file on another drive and have been unsuccesful. When I re-attach the database Enterprise Manager puts a path automatically on the same drive as the DB. When I try to change to the new drive it goes back to what EM selected. Any suggestions? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
SQL Transaction Log File