SQL Backup often requires you to specify a file path or name, as for example in the Back Up wizard:
You can type the file path and name in the boxes. To specify a network path, type the full path, including the server name, for example \\ServerName\MyFolder\MyFile
Note that the file path is relative to the selected SQL Server. For example, if you have chosen to back up a database on a remote SQL Server instance called ServerA and you specify a local path such as C:\Backups, the backup files will be created on the C: drive on ServerA, not on the local server.
Alternatively, you can click 
to browse to the folder or file you require. For example:
SQL Backup displays the local file system for the selected SQL Server.
To see the files on a network share:
- In the Browse box, select
Network shares. - In the Server box, type the name of the network share, or type the IP address.
- Click Add Server to List.
To remove the network share from the list, right-click the network share name, and click Delete.
Browsing SQL Servers with SQL Server authentication
If you are using SQL Server authentication on a SQL Server, for security reasons browsing to folders or files on the SQL Server is disabled by default. This is to prevent information about the file system structure being revealed to SQL Authenticated users who do not have permissions to browse the file system on the SQL Server.
You can override this restriction. However, you should do this only after careful consideration.
To enable file browsing by SQL Server users, in the registry folder:
32-bit machines: HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
64-bit machines: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
create the registry key AllowSQLBrowsing as type DWORD, and set the value to 1. You must have administrator privileges to do this.
© Red Gate Software Ltd 2008. All Rights Reserved.