We need more info. Are your different databases related, so that there might be common tables and SPs in multiple DBs ? Or are you combining unrelated...

RESOLUTION: There was a duplicate IP address caused by dhcp after upgrading to Windows Server 2003. It has been removed, so that should resolve it.

Thanks to everyone for all the...

FWIW:

I just tried to ping the server & it timed out, although I could remote desktop into it, so it is up & running. Normally, I have been connecting with...

+1

Could you do "in-place" ?? side-by-side seems like so much more work, but may be required in your situation.

Are you doing "In-Place" upgrade or "Side-by-side" upgrade ? I've just done "In-Place" upgrade and I didn't have to do anything for replication. It kept right on working...

Put on Service Pack 2, then you'll get it (not sure about SP1)

We use a similar product, SQLSafe by Idera. Works quite well. Otherwise, you could xxcopy the backuping across the network, then doing the restore locally. That's what...

Thanks for all the replies !

BOL has this about ALTER INDEX (replaces dbcc dbreindex), so maybe I can reindex while users are accessing the tables, even though I'm in 80...

ALZDBA (10/30/2007)

---

- also keep in mind with an in-place upgrade, all your databases (including the system databases) are still at db_level 80 (sql2000) !

- If you want to use the...

I have not re-indexed anything. I encountered some problems over the weekend during the upgrade & ran out of time. Is it recommended to rebuild all indexes ?

I ran into a couple of issues installing a separate instance of 2005 on a box that already had 2000. One issue was a conflict with JDBC drives ... it...

Henrik Holm (10/28/2007)

---

Update:

after approx 32 hours the db files were created, then i thought my db was ready, but no. It took another 34 hours where the db appeared as...

Are you doing it through the GUI ?? I think I remember that in SQL 2000 I would get timeouts using the GUI because it had a timeout setting...

Or use a product like Idera's SQLSafe (or others) that will compress the backup from 90 G to 15-20 G. Then you can copy faster. The Idera restores are a...