Sharepoint 2010 Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint 2010       RSS Feeds

Moving All The SharePoint 2010 Databases...

  Date: May 29    Category: Sharepoint 2010    Views: 1356

I have A very urgent query and scenario which is as follow:
I have a Live SharePoint 2010 Server with 2 SQL Server 2008 R2 Boxes Running as
All the DB's is stored on the Server Driver.
Now, I need to Move All the current DB's to a new SAN storage, Also i need to
change the Default SQL Server DB's Directory to the New SAN Storage.



6 Answers Found

Answer #1    Answered On: May 29    

Did you use SQL alias??????????????????????

Answer #2    Answered On: May 29    

NO. Name alias is not currently used.
BTW, it would really be nice if someone can tell me and share some informations
or documents regarding:
1- Installing SQL server 2 boxes in cluster using alias.
2- What if again I want to move the DB's to onther server or directory, so how
to do if I already have alias.

It'll be really nice if someone help me on such scenarios.

Answer #3    Answered On: May 29    

SQL aliases are defined at the "client" side of the connection to SQL.
There's nothing to configure on the server side (unless you are actually
running a client on the server like the case of SharePoint and SQL on
the same machine). Decent overview at

Answer #4    Answered On: May 29    

Microsoft has this process documented very well... have you gone out to Technet
and searched for this?

Answer #5    Answered On: May 29    

Moving SQL database data files and logs shouldn't pose much of a problem if
you are using the same SQL Server 2008 instance.

You just need to bring down the SP farm before moving the databases so there
are no open connections.

Answer #6    Answered On: May 29    

Ok wait... I read the posts, but I am not sure if you are explaining correctly.

1- Are you changing SQL servers or is it Just the SAN provider that is changing?
2- what is your farm topology?

If you are changing SQL servers, then the fastest thing to use is the SQL
alising. These would have to be configured on your sharepoint servers. The WFE's
and App servers using the CLICONFG command from the run line.

If your SAN provider is changing, then the move can be done from the SAN side
and your servers are not really impacted except for the downtime since you
should shutdown SQL while the perform the SAN move.

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