AspAlliance.com LogoASPAlliance: Articles, reviews, and samples for .NET Developers
URL:
http://aspalliance.com/articleViewer.aspx?aId=1068&pId=-1
CodeSnip: Take SQL Server Database Backup in any Network Path
page
by Jaya Nehru Kumar
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19379/ 30

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.

Summary

In this step-by-step snippet you learned how to make backups of a SQL Server database in any network path.



©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-02-26 2:07:51 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search