October 12, 2002 at 11:44 am
In our test lab, I took the MDFs\LDFs from a working Sql 7 server and copied then to the "DATA" folder on a sql 2k server (I stopped the sql 2k server and deleted all files from its DATA folder before copying the sql 7 MDF\LDFs in).
Then I restarted the sql 2K server and everything seems to work fine. Was I lucky or is this an actual "upgrade" path that works?
TIA,
Bill
October 12, 2002 at 2:59 pm
Nope, it works. The data structures get upgraded automatically/transparently. One thing they got right.
Andy
October 12, 2002 at 3:23 pm
The only thing that sometiomes occurrs, is that it bloats the DB during the upgrade, not usually much but it is noticeable. It is best to run sp_updatestats, DBCC REINDEX all the indexes, and DBCC UPDATE USAGE. This will correct the problem, which does not always happen, but does happen often.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply