I have recently migrated from SQL Server 7 to SQL Server 2000.
They way that i did that was by restoring from a backup of the old
server. I then went and did all the admin stuff that you do on a new box, set up back ups and db maintenance plans. This is where my problem is. The optimization step of my db maintenance plan runs for ever. im talking days. I eventualy have to kill it. What is going on? is it because of the way that i migrated? What else could cause a optimization job to run forever?
Regards Jim