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 |
|
jasraja
Starting Member
22 Posts |
 Posted - 2007-06-11 : 08:15:23
|
| Hi All,I have a requirement of migrating all databases from one server to another. I need to backup all SQL Server 2005 databases (both SQL and AS) with the exact replica copy. Also I need to migrate all the SSIS packages. Unfortunately I am not a Database/System Admin.Is there any Script/Tool/Wizard Functionality that would help me doing this? I would be happy, even if you can help me reducing the parts of manual work in anyway you can think of, so please pour you thoughts in.Thanking in Anticipation,Jasraja |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 08:22:43
|
| Well, this doesn't answer your question, as such, but it considers the steps to go through in migrating to a new sever, so may give you some ideas or prevent you falling into some potholes!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Move%20database,Moving%20to%20a%20new%20sql%20server,Fix%20Orphaned%20UsersIf you are LITERALLY moving everything to a new server you can:Install SQL on new server(Make 100% sure that the installation is identical INCLUDING Drive\Path for system databases, and Service Pack)Stop SQL Service on BOTH the Old and New serversTake copies of the System Database files on New Server - "Just in case"!!Copy all the System AND User database files (MDF & LDF - and maybe NDF) from Old to New serverRestart SQL Server Service on the New box(If necessary "Move" the database files to different/better physical/logical locations)(So in effect you will have overwritten the System databases on the new Server with those from the Old Server)Kristen |
 |
|
|
|
|
|
Backup All Databases(SQL and AS) and SSIS Packages