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 |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2009-04-29 : 05:14:46
|
| Hi,What is the easiest way to migrate a 2005 Express installation from one server to another. I want an exact copy, all databases, logins, settings etcThanks |
|
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
Posted - 2009-05-22 : 10:01:39
|
| *bump* |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-05-22 : 18:10:15
|
| This was true for sql2000Install exact same version /sp level, in the exact same file path as the previous server. (ie C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)Stop ServiceMove all the mdb / ldb files over (rename existing data folder put copy of data folder in its place)Start SQL Service.Profit.If you need to change the file path for the databases, there are some steps you will need to follow. |
|
|
|
|
|
|
Migration