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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2008-01-08 : 09:51:11
|
| Hello All,Can I move the sql log files from one server to another server? I know we can move the log files to another drive on the same server but I am not sure if we can move them to another server all together.Can anyone tell me the answer?Thanks-P |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-01-08 : 09:59:35
|
| Database files must be kept on the same server. This includes .MDF, .LDF, and .NDF files. You can optionally move the entire database to another server, by detaching the database, moving all associated files, and reattaching to a database engine on another server, though. |
 |
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2008-01-08 : 10:04:01
|
| I know they must be kept on the same server. But is it possible to keep them on the different server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:56:15
|
| You can copy it to anywhere, but any reason for that? |
|
|
|
|
|
|
Moving log file to another server