SQL Server Performance

Change Default backup folder in a SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by CanadaDBA, Jul 8, 2008.

  1. CanadaDBA New Member

    How can I change the default backup folder in a SQL 2005? I think at the time of installation it is set to D:somewhere and I want to change it to somewhere else. The problem is that when I want to backup manually, get an error that D:somewhere does not exists and then I have to enter the new path.


  2. fromnaija New Member

    The default backup folder is set during installation and saved to the registry. You could change it here for the default instance:
    HKLMSoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer.
    On a SQL Server 2000, the default backup folder is also stored in the registry here for the default instance:
    HKLMSoftwareMicrosoftMSSQLServerMSSQLServer
    The usual caveat applies: backup your registry before making changes!
  3. peace2007 New Member

    I came to that path in registry and couldn't find the default backup path[:$]
    could you help me find that?
  4. satya Moderator

  5. Mahmoud_H New Member

    modify the registry key:

    HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServerBackupDirectory
    the default of that entry is:
    C:program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup
    you can modify it
  6. MohammedU New Member

    You can specify the backup location in your backup command....
    Is there any reason to change the default backup directory?
  7. peace2007 New Member

    Thank you mahmoud I found that :)
    I was just curious about it
  8. countryfriedsql New Member

    [quote user="MohammedU"]
    You can specify the backup location in your backup command....
    Is there any reason to change the default backup directory?
    [/quote]
    No offense, but spoken like true die-hard MS :) "why would anybody want to do that?" :) "why would anybody need more that 640 k of memory?"

    If there is a need for a default backup directory in the first place, then there is a need for someone to change it sometime.
    Thanks for the reg entry, it will help when creating new backups to not have to change the location every time.
  9. sqlSilvey New Member

    If you prefer to change via a GUI.
    Through SQL Server configuration manager. Under SQL Server 2005 Services, right click on the the SQL Server (MSSQL Server) service. Select properties, then select advanced tab. It will be listed under DUMP DIRECTORY.
  10. jherrick New Member

    That didn't work for us. The caption for that setting indicates it is only for error log files. We needed to make the change in the registry.

Share This Page