locked
default save location RRS feed

  • Question

  • How can i change the default folder to which my database files are saved?  right now it's saving everything to

    \program files\mssql server\mssql.1\mssql\data

    uggg!  i can't even find an option to use a "save as" or export the mdf file.  the "save as" tries to save the solution file.  Any help is greatly appreciated.
    Tuesday, July 10, 2007 5:09 PM

Answers

  • Using SSMS, right-click on the server in Object Explorer, select [Properties], then click on the [Database Settings] tab.

     

    Change the Default Database location in the setting pane.

    Tuesday, July 10, 2007 5:45 PM

All replies

  • Using SSMS, right-click on the server in Object Explorer, select [Properties], then click on the [Database Settings] tab.

     

    Change the Default Database location in the setting pane.

    Tuesday, July 10, 2007 5:45 PM
  • If you want to change the location of the already existing database file, you should consider using the detach / attach functionality which is described in the BOL. Be aware that during this process, the database (not the instance per se) will NOT be available for incoming connections.

    Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Sunday, July 15, 2007 1:07 PM