In MS SQL Server the backup wizard does not show the network's
path to store the backup database. The reason is the MS SQL Server instance is
running under Local System Account.
Follow the steps given below to make a backup of a SQL
Server database in any network path.
Step 1
Start | Run | Enter services.msc
Step 2
Stop the MS SQL Server service
Step 3
Right Click and choose the properties in
MS SQL Server Service.
Step 4
Choose the logon tab from the tabbed
pane.
Step 5
There will be two radio buttons, Local
System Account and User Account. Select User Account. Once selected there will be two text boxes to
enter the username and password down below the selected option.
Step 6
Provide the username of the person who has rights to access
network locations and the password for him or her.
Step 7
Close the tabbed pane and Restart the Service.
Step 8
Now the Backup wizard will show the network path.
