Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 General questions : 2008 upgrade

Author  Topic 

roykauf
Starting Member

36 Posts

Posted - 2008-11-05 : 06:50:31
Hi all,
I'm upgrading my server from SQL 2000 to SQL 2008. I have some questions:

What is the role of database Master on SQL2008?
What is the role of database MSDB on SQL2008?

Why should I make rebuild to the Master database? ( on a new installed server)

What are the standard / basic procedures/configuration settings when upgrading from SQL 2000 to SQL 2008?

Thank you for you help.

Roy

gedwards
Starting Member

19 Posts

Posted - 2008-11-05 : 16:32:13
You might want to start here:
http://msdn.microsoft.com/en-us/library/ms144256.aspx
There are some substantial differences between SQL 2000 and 2005/2008 - especially for DTS and Cubes.
Greg E

Greg E
Go to Top of Page
   

- Advertisement -