MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Changing db on a stand alone installation from sqlexpress

  Asked By: Sonya    Date: Jun 02    Category: MOSS    Views: 706

As you all probably already know, when you choose a stand alone installation
of MOSS, it installs and uses SqlExpress by default. Does anyone know if it
is possible to switch later? On my stand alone server, I already have Sql
Server 2005 installed, and would rather use it than the newly installed
SqlExpress. Backing up the databases and restoring them on Sql 2005 is easy,
but where does MOSS get the configuration information to tell it what Sql
instance to use for central admin and content?



4 Answers Found

Answer #1    Answered By: Amanda Brown     Answered On: Jun 02

You can detach the content databases, move them to another SQL server
and attach them. That's pretty easy. As for the config database, I
think you'll have to rerun Configuration Wizard and recreate it. I
haven't seen any way to move the config database, or the SSP databases.

Answer #2    Answered By: Carey Everett     Answered On: Jun 02

Once I reattach the content db on the new server, where do I configure MOSS
to look at the new location instead? I'm hoping there is some way to move
the config db and SSP db as well. If not, oh, well. But it would be nice.

Answer #3    Answered By: Anuj Lakhe     Answered On: Jun 02

You reattach it at the same place you detach it. Central Admin >
Application Management > Content Databases.

Answer #4    Answered By: Lee Dickerson     Answered On: Jun 02

I thought you were talking about detaching\attaching the
databases in sql server. That would, of course, have to happen as well,
correct? So, it would work like this:

-Detach content database via central admin
-Detach db in sql server
-Attach db in new sql server  instance
-Attach content database via central admin

Is this correct?

Didn't find what you were looking for? Find more on Changing db on a stand alone installation from sqlexpress Or get search suggestion and latest updates.