CodeSnip: Take SQL Server Database Backup in any Network Path: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: Take SQL Server Database Backup in any Network Path

page 1 of 2

Published: 20 Nov 2006

Abstract
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
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 17571/ 19

Article Contents:

Introduction

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

(Page 2) »

User Comments

Title: Feedback
Name: Feedback
Date: 2011-03-30 4:39:59 AM
Comment:
Hi,
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
Comment:
thanks for sharing this

Title: back up tree
Name: john
Date: 2010-10-01 5:43:10 AM
Comment:
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
Comment:
Hey Can u Tell ME How Do i Get Back-up Of SQL Database using asp.net....

Title: Backup Database in ASP.net
Name: sone
Date: 2008-12-31 9:38:53 AM
Comment:
\
\S
\

Title: Backup Database in Network Path
Name: Nalin Sampath
Date: 2008-10-03 11:33:16 PM
Comment:
Not Working..............................

Title: How i get backup my data base
Name: Aman Miglani
Date: 2008-02-03 5:42:09 AM
Comment:
hi i am a asp programer i want to get dadabase backup plaase
help me.

Title: CREATE BACKUP FILE FROM SQL DATABASE
Name: HARVINDER
Date: 2008-01-25 3:13:36 AM
Comment:
how i can create backup file from sql database

Title: Username and permission
Name: Vincent Augustine
Date: 2007-07-10 4:48:24 AM
Comment:
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
Comment:
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
Comment:
I done as stated above but i am not able to see netwoek paths on both server and client also