locked
How to change default database server in WSS 3.0 to SAN path RRS feed

  • Question

  • We have moved all of our content database to our SAN share.  Now we want all of our new content databases to be automatically created in this share.  When creating a new application, how do I modify SharePoint Services 3.0 to propagate the path to the share in the database server field?
    Wednesday, February 9, 2011 6:58 AM

All replies

  • Hi,

    Please refer this:

    http://blogs.msdn.com/b/ronalg/archive/2007/09/20/change-the-sql-server-in-a-moss-2007-wss-3-0-farm.aspx

    Hope it could help


    Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"
    Wednesday, February 9, 2011 11:53 AM
    Moderator
  • So it looks like I can't have the database created in a directory on a share.  It must be created in a database.  Then my only option would be to install SQL on the SAN and move my SharePoint database to it, correct?
    Thursday, February 10, 2011 6:37 PM
  • Yes. Ifyou plan to take that route, make sure you use a SQL server alias since that alias can then be pointed to any SQL server.
    Thursday, February 10, 2011 6:52 PM
  • Are there any options that do not involve using a new database?  Is there any way to save the content database directly to the SAN directly?
    Saturday, February 12, 2011 1:33 AM