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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-09-12 : 04:59:44
|
| Hello ,I have a database with datafile and log files as follows . For e,g Data file - d:\mssql\data\db1.mdfLog file - d:\mssql\data\db1.ldf and E:\mssql\tlog\db2.ldf Now i want to have the log file ( .ldf ) only in one drive E: and remove the ldf file from the d: drive so that i can one single log file . How can i transfer the ldf file from D: to E: drive path ? Is it possible to do it on line with the users connected ? I believe , the database has to be offline to do such activities of moving the data or the log files . Any suggestions or comments ? Thanx |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-09-12 : 10:33:21
|
| This process does not support users being connected.Detach database.Move log file to D driveUse sp_attach_db (read BOL)HTHs solart |
 |
|
|
|
|
|
Moving log file to a single directory .