CodeSnip: Take SQL Server Database Backup in any Network Path
page 1 of 2
Published: 20 Nov 2006
Normally, MS SQL Server backup wizard will not show s network's path to store the database. This code snippet will show the way to store MS SQL Server database in a network path.
by Jaya Nehru Kumar
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 17279/ 27
Article Contents:


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.

View Entire Article

User Comments

Title: Feedback   
Name: Feedback
Date: 2011-03-30 4:39:59 AM
I tried this on my local sqlexpress installation and it does not work. I have set the "logon As" property for my sqlexpress service as my domain user, who has full rights to domain network. But the backup wizrd shows only my local drive. the domain user is an Administrator on my machine.
Please Help
Title: property for sale   
Name: property for sale
Date: 2011-03-04 7:22:53 AM
thanks for sharing this
Title: back up tree   
Name: john
Date: 2010-10-01 5:43:10 AM
how to do make my backup server in my office or at home
Title: Back up On Fly Using Asp   
Name: Shokeee
Date: 2009-06-04 8:50:30 AM
Hey Can u Tell ME How Do i Get Back-up Of SQL Database using
Title: Backup Database in   
Name: sone
Date: 2008-12-31 9:38:53 AM
Title: Backup Database in Network Path   
Name: Nalin Sampath
Date: 2008-10-03 11:33:16 PM
Not Working..............................
Title: How i get backup my data base   
Name: Aman Miglani
Date: 2008-02-03 5:42:09 AM
hi i am a asp programer i want to get dadabase backup plaase
help me.
Date: 2008-01-25 3:13:36 AM
how i can create backup file from sql database
Title: Username and permission   
Name: Vincent Augustine
Date: 2007-07-10 4:48:24 AM
Working.. fine. Username is a network username who has permisstion to write to the network backup destination folder. One more thing add this network user to the administrator group of the local system where sql server is working.
Title: check the user permission   
Name: Jaya Nehru Kumar
Date: 2006-11-23 10:02:46 AM
After testing ONLY this code snippet is provided
what is the user account you have given
could you please tell me?
Title: Not working   
Name: prashant
Date: 2006-11-23 7:21:52 AM
I done as stated above but i am not able to see netwoek paths on both server and client also

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-06-18 4:40:25 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search