Yup this works just fine. Just once you go to the "dark side" you can't
go back.



Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886


-----Original Message-----
From: Monte Kottman
[mailto:mssqldba-ezmlmshield-x80830477.[Email address protected]
Sent: Thursday, August 31, 2006 7:18 AM
To: LazyDBA Discussion
Subject: Interesting Upgrade Path

All,

I just upgraded a test server from 2000 to 2005 the other day
and I tried a migration path for the databases that I wasn't sure if it
would work, but it did and I was wondering if there were any "gotcha's"
lurking in the background. I merely stopped SQL 2000, copied the MDF,
LDF files to another drive and attached them to SQL 2005.

It seems to work very well, with only a few minor sp problems
that I am addressing, but am I forgetting/ignoring something?

Thanks all!!

Monte Kottman


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


************************************
This e-mail and any files transmitted with it are proprietary and intended solely
for the use of the individual or entity to whom they are addressed. If you have
received this e-mail in error please notify the sender. Please note that any views
or opinions presented in this e-mail are solely those of the author and do not
necessarily represent those of ITT, Inc. The recipient should check
this e-mail and any attachments for the presence of viruses. ITT accepts
no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page