Avatar of J.R. Sitman
J.R. Sitman
Flag for United States of America asked on

I need to move an SQL 2005 database to a SQL 2008.

I need instructions to move an existing database from one server to another in the same domain.  
I read through several posts on EE, but could find one that I believe is my same situation.  
I need this done today so max points.

The existing server is 2003 and the new is 2008 R2.
Microsoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment
J.R. Sitman

8/22/2022 - Mon
Paul Jackson

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

anything else going on?

does the database participate in replication ... mirroring etc....

any batch jobs etc to migrate,,,

what about any front end applications?

1.  ensure you have an upto date copy and run the upgrade advisor and see if there are any
     immediate issues you need to deal  with....

2.   as mentioned by jacko72 those are the 2 basic methods....
     you could also create a new database and use replication to migrate the data an structures across.... that may allow you a period of parallel running, and minimise application downtime...

3.   you basically need to choose between leaving the database in sql 2005 (or earlier ) compatability mode, or hoing for 2008  from the start...

4.  test test test...
J.R. Sitman

WOW that was way to simple.  All the other posts I read were complicated.

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck