Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Changing Database for Sharepoint

  Asked By: Conrad    Date: Feb 11    Category: Sharepoint    Views: 908

i want to change the SQL Database file from Hard disk to the SAN
without destroying the sharepoint ,how can i make this ??



2 Answers Found

Answer #1    Answered By: Benito Carey     Answered On: Feb 11

Basically you want to backup the current database  and restore it at
the new locations. It's not a simple process.

I've been investigating this process recently and have found several
good resources via google. Research this well before you try it.

Answer #2    Answered By: Ebony Perkins     Answered On: Feb 11

When it comes to databases sharepoint  only really cares about two
things, sql  instance and database  name. If you're not going to change
either one of those, SharePoint doesn't care or need to know. If you're
moving from hard  drive to SAN on the same SQL server there's nothing to
it. Shut SharePoint down, move the databases in SQL and fire SharePoint
back up. If in this process you're going to be changing  the SQL
instance name then create a SQL alias to the new Instance. Here's how
to do that,
aspx. Again, nothing to do in SharePoint. You can also look into the
STSADM operation "renameserver" to do some of that too.

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