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-09-30 : 08:58:57
|
| Eric writes "What are the requirements in moving transaction logs to another volume share?What I'm thinking is to stop services then physically move(OS level) the transaction log files to their new location, then modify the default sql log file path within enterprise manager to the new location. Then start back up the services.Does enterprise manager take care of the physical move of the existing transaction logs when the default log path is modified, or does it simply state the path where logs are to be written to?Also, I have replication running. Are there any other steps I need to take in regards to replication, so I do not disrupt replication?Thanks." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-30 : 09:29:04
|
| Don't do that !1) Put database in single user mode2) Detach the database using sp_detach_db 3) Move the OS files to the new location4) Reattach the db using sp_attach_db 5) Put database in multi user INF: Moving SQL Server Databases to a New Location with Detach/Attach[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071[/url]HTHJasper Smith |
 |
|
|
|
|
|
Moving Transaction logs to another volume.