Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Moving Databases

  Asked By: Mack    Date: Sep 08    Category: Sharepoint    Views: 663

I have a SharePoint development environment that is connected to a dedicated SQL
2005 server. I would like to move the databases off this SQL server onto a
different SQL 2005 server, does anybody have a step by step procedure on how I
can do this or point me to a reference?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Michelle White     Answered On: Sep 08

You will have to run stsadm -o preparetomove before you do this - I'm
not sure that's the only step, but that's a major step.

 
Answer #2    Answered By: Sheena Ray     Answered On: Sep 08

Here are some resources that you can use:

blogs.msdn.com/.../moving-the-sharepoint-da
tabases-to-a-new-sql-server-instance.aspx

blogs.technet.com/.../moving-your-moss-200
7-databases-to-a-larger-drive.aspx

Hope these help. Its actually a pretty painless operation.

 
Didn't find what you were looking for? Find more on Moving Databases Or get search suggestion and latest updates.




Tagged: