When selecting to back up your data from within Acctivate, Acctivate sends a command to Microsoft SQL Server to start a backup. Microsoft SQL Server typically sets the default location of Backups to be within the SQL Server instance subdirectories. An example of this, where the SQL Server instance name is ‘ACCTIVATE’, would be a directory path of:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACCTIVATE\MSSQL\Backup
Microsoft SQL Server typically offers two ways to change the backup location for each SQL Server instance. The first, much safer and more common option, is to change the SQL Server Instance Backup Location by using SQL Server Management Studio.
- On the Windows Server in which SQL Server is installed on, go to Start -> Programs -> Microsoft SQL Server.
- Select to open SQL Server Management Studio. If you don’t have SQL Server Management Studio installed, you can download SQL Server Management Studio from Microsoft’s website. Simply search for Management Studio for the SQL Server version you currently have installed.
- Log into SQL Server Management Studio using either sql authentication or windows authentication if you are logged into Windows as an Administrator.
- Right-click the SQL Server instance and select Properties.
- Select the Database Settings section. At the bottom of this window, you should see the Backup default location.
- Browse to the new Backup location and then close.
Another option would be to modify the default Backup Location from within the Windows Registry. This option is a little more advanced and there is a risk of causing problems since you are selecting to modify registry keys. This may be a better option if you don’t currently have SQL Server Management Studio installed.
- Before beginning, back up your registry.
- With the registry open, browse to the SQL Server instance registry keys for your related named instance. An example of the key for my SQL Server 2008 instance, named ‘ACCTIVATE’ is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.ACCTIVATE\MSSQLServer
- You should find a key named ‘BackupDirectory’. If you don’t immediately find the BackupDirectory, you can consider searching the HKEY_LOCAL_MACHINE registry for ‘BackupDirectory’.
- Right-click the BackupDirectory key and select to edit.
- Enter in the new Backup Directory of your choosing.