Welcome: Guest!

MOSS Forum

 
Home » Forum » MOSS       Ask a questionRSS Feeds

MOS 2007 SQL 2000->2005 Move

  Asked By: Connor Vazquez         Date: Jan 22, 2007      Category: MOSS      Views: 215
 

Due to a hardware failure I'm gong to need to setup a new SQL server.
I've decided that it'll be better just to move to SQL 2005 at the time
of reinstallation.

Is there anything special I need to do to move MOSS 2007's DBs to SQL
2005?

I'll be using SQL 2005 x64, and coming from SQL 2000 SP4.

Tagged:            

 

1 Answer Found

 
Answer #1       Answered By: Graham Ingram          Answered On: Jan 22, 2007       

The answer is that I simply detached the DBs and the reattached them on the SQL
2005 server without appearant issue.

I did not upgrade them to SQL 2005 via an import, as I've no idea if that's the
proper procedure.

 
Didn't find what you were looking for? Find more on MOS 2007 SQL 2000->2005 Move Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
Hall of Fame  |  Facebook  |  Twitter  |  LinkedIn  |  Terms of Use  |  Privacy Policy  |  Contact us
RSS Feeds: Articles |  Forum |  New Users |  Activities |  Interview FAQ |  Poll |  Hotlinks


Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.

Copyright © 2008-2011