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 |
|
keithc
Starting Member
35 Posts |
 Posted - 2005-04-25 : 13:48:27
|
| Hi I installed SQL and have specified new default location for T-Logs when new DB's are created. What I was wondering is can I move the T-Log location that was created during setup to a diff physical drive for system DB's? If so how Thanks |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-25 : 15:02:54
|
| You can use sp_detach_db and sp_attach_db. Check Books Online. I recommend making a full backup before doing this. |
 |
|
|
|
|
|
Transaction Log File location