Upgrade from 7 to 2000 - Advice please

  • Hi,

    I have just been given my first project as a DBA (was previously a developer). Can anyone give me some pointers on the type of things I will need to consider and watch out for, in order to successfully upgrade from 7 to 2000.

    A possible added complexity on this is that when the upgrade is complete, I have to implement clustering.

    Thanks for any pointers in advance.

    Rootman

  • The worst thing I found out today is that a reindex job for a couple of tables(high volume) in 2000 fills around 5 GB of transaction log entries but the same job running in 7.0 server with the same database and tables, fills only a few MB in the transaction log. I used Log explorer and found out that in 2000 he makes lot of log entries like Format page, modify rows etc,.

    Can anyone explain this...

  • It is a straightforward change. I don't think there are any new keywords. If there are, you can always set the databases to run as sql 7 compatible.

    Steve Jones

    steve@dkranch.net

  • You can use Copy database wizad or sp_attachdb and sp_detachdb too.

    This might be useful http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246133&ID=KB;EN-US;Q246133& .

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply