Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Moving Sharepoint Databases to New 64 bit SQL Server

  Asked By: Brittanie    Date: Aug 31    Category: Sharepoint    Views: 15811

I want to build a new 64 bit SQL server with the same name as my
current 32 bit Sharepoint SQL server and move the databases over. Does
anyone know of a reason this won't work?



6 Answers Found

Answer #1    Answered By: Xavier Hopkins     Answered On: Aug 31

We have just made the move  from 32-bit to 64-bit, with no major issues. Are you
going to connect the databases  to your current environment, or moving  to a new

Answer #2    Answered By: Viviana Rollins     Answered On: Aug 31

I was hoping to use current environment which consists of 1 web front
end and 1 Index server.

Answer #3    Answered By: Erika Price     Answered On: Aug 31

Start here: technet.microsoft.com/en-us/library/cc263447.aspx There is a
digital book too at the bottom of the page that addresses upgrade paths. There
may be more information there.

Also, I share this site as a good source for those wanting to understand all the
different db(s) that make up your farm. SEE here:

Good luck. Be sure to write back what you end up doing and the results and
lessons learned.

Answer #4    Answered By: Otis Blackwell     Answered On: Aug 31

Has anyone had any experience migrating their content database from SQL 2005
to SQL 2008 on another box? If so are there any resources out there that you
could point me to?

Answer #5    Answered By: Virendar Chaudhari     Answered On: Aug 31

I've done it. There's not much to it. You can restore SQL 2005 database
backups to SQL 2008 without any other work. SQL is good about upgrading
databases when you attach it. Read through this, too,
stsadm.blogspot.com/.../...databases-easy-way.html It
doesn't call out SQL versions, but it doesn't have to. There's no extra

Answer #6    Answered By: Mitchel Villarreal     Answered On: Aug 31

we did a couple of practice runs to make sure we could make the move  with no
issues, and like you said, there is not much to it.

Didn't find what you were looking for? Find more on Moving Sharepoint Databases to New 64 bit SQL Server Or get search suggestion and latest updates.