Thanks for nice sharing.

-----Original Message-----
From: Monte Kottman
[mailto:mssqldba-ezmlmshield-x80830477.[Email address protected]
Sent: Thursday, August 31, 2006 4:48 PM
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



MS Sql Server LazyDBA home page