June 17, 2002 at 11:08 am
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
June 17, 2002 at 12:38 pm
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...
June 17, 2002 at 1:35 pm
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
June 17, 2002 at 11:53 pm
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