Good question. The detail-oriented person earns 1 point as reward. 🙂

Thank you. Great info! Worth rereading.

"Regular shrinking is not advisable...

How about this?

select * from sys.databases where database_id > 4

Thank you for sharing. This method is definitely worth a try.

I used full backup & transaction log backups for a 300 GB migration, not log shipping though.

Restoring the full...

Thank you Kendal.

How big was your database? How much down time in your case? Any performance problem for using this method?

To clarify, I want to upgrade SQL2000 database from the existing server to a new server as SQL2005 database with minimum down time. Backup & restore/detach & attach take...

Database is being Logged shipping from SQL2000 to SQL2005. If we can not use SQL2005 database on the destination server, what is the log shipping for? 😉

Do you work for FBI? 😉

OK, no asking this question any more to save both you and me.

You mean it can not be used for database upgrade? Do you know why not?

TheSQLGuru (4/18/2008)

---

No queries to post, but I will add that the query optimizer was so modified between 2000 and 2005 that there were bound to be lots of regressive-performing situations....

Is your replication a real replication or backup/restore? Seems there are a lot of manual processes for replicating the data?

right click the database--> tasks--> shrink--> files

or DBCC SHRINKFILE http://support.microsoft.com/kb/907511

"The password takes...

tosscrosby (6/2/2008)

---

Thanks MohammedU 😀 Some posters want everything given to them without any effort on...