Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upgrading MSDE database

Status
Not open for further replies.

bkirkflex

IS-IT--Management
Jun 12, 2006
76
US
We will be upgrading our SharePoint MSDE datbase to SQL 2000. Once this is done how do I get Sharepoint to "see" the new database?

Thanks
 
What we are planning to do is to detach the databases from the MSDE engine, remove MSDE, then attach the databases with SQL 2000 engine.

Does this sound like it will work?

Thanks in advance.
 
What type of authentication are you using for the database? mixed, or windows.

Be sure to make a backup of the database prior to detatching. It could be easier to backup the database from MSDE, then restore it using SQL 2000.
 
Hi,

Microsoft has released whitepapers and upgrade instructions (step-by-step) for this which you might want to look at before doing any changes. Just do a search on the MS website.

Cheers,
Thomas



 
jeffinperth;

Thanks. Those instructions are for SQL 2005, and we have installed SQL 2000. Would the instructions work for SQL 2000 as well?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top