Post reply

Default database location

  • September 14, 2007 at 6:05 am

    #153824

    I work in a very small IT shop where we use SQL Server 2005 standard edition.  We have no dba support.

    When I create a database I use the default location (e.g., C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

    I'm concerned if I ever need to uninstall/reinstall SQL Server that my database files (mdf and ldf) will be lost.

    Should I choose a different location for my database, such as, 'c:\data'?

    Do I need to be concerned at all?  Will an uninstall/reinstall of SQL Server preserve my databases?

    Thanks.

  • September 14, 2007 at 6:30 am

    #733740

    Definitely u can choose other locations..Not only in other folders u can also give ur mdf and ldf in other drive also...Alll ur mdf and ldf files are safe even if u do an unstall and reinstall..

  • September 14, 2007 at 7:22 am

    #733762

    Thanks, Ratheesh!

  • September 14, 2007 at 5:47 pm

    #733926

    Uninstall/re-install will not remove the files, but that doesn't prevent someone from just deleting the directory.  Even with a small shop, you should setup some sort of backup process.  What happens if you hard drive fails? 

  • September 15, 2007 at 2:57 am

    #733947

    Thanks. Bob.

    We do have a backup process to tape.

    I posted the question because the other developer I work with believed that an uninstall/reinstall of SQL Server would delete the database files from their default locations. 

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply