System Databases affected when upgrading from SQL 2000 to SQL 2008

when upgrading from sql server 2000 to 2008 all system databases were rebuild and user database attach, should the Microsoft SQL Server 2008 Upgrade Advisor have pointed out problem with the system database while in the process of upgrading?

if the msdb database does not upgrade from sql server 2000 to 2008, should one restore and rebuild to get the old legacy dts, obs and maintenance

more ▼

asked Nov 20, 2009 at 11:00 AM in Default

DBAJM gravatar image

11 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

The structure of system databases changes with each version, or it potentially can. You should expect that all system databases will change on an upgrade. This is not something I would expect the Upgrade Advisor to note. It's not a problem. Your logins will move, as will the maintenance items.

If they did not, you have another issue.

more ▼

answered Nov 20, 2009 at 02:04 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 78 79 82

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 20, 2009 at 11:00 AM

Seen: 1493 times

Last Updated: Nov 20, 2009 at 12:25 PM