Should be as simple as attach. You can also set the db compatibility back down to 2000 level.
--Tigran On Wed, May 18, 2011 at 1:06 PM, James Kerr <[email protected]> wrote: > I need to move a database from a 2003 server running SQL 2000 to a machine > running 2008R2 and SQL 2008R2. Should this be as easy as dismounting the > database and copying over the database files to the new server or will SQL > 2008 require me to do some kind of upgrade to the database first? > > James > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
