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 - 2004-03-31 : 08:48:11
|
| CY writes "Dear experts,I have bought a new handdisk for my server and want to move the sql database to the new one, Can I do this without reinstalling the sql server? If it can, how I can do that?Thanks for your help." |
|
|
MuadDBA
628 Posts |
Posted - 2004-03-31 : 09:36:11
|
| yes, you can. look up sp_detatch_db in the BOL. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-31 : 12:25:30
|
| After you run sp_detach_db, copy your MDF and LDF files to the new directory. Then run sp_attach_db.Tara |
|
|
|
|
|
|
Move database between two handdisk within the same server