Re: How to Backup Database File Location In Network Drive ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 08:08:45 -0600

To add to the other responses, the SQL Server service needs to run under an
account with permissions to the network share used for backup. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Kelvin" <kelvinweb@gmail.com> wrote in message 
news:db7965c.0412290122.71ed48d4@posting.google.com...
> Hi All,
>
> I want to backup database file on network drive, but It can't show
> mapped network drive on the SQL Server Backup Function. Please advise.

Relevant Pages

  • Re: Backup permission
    ... Other thing that i dont understand is that when a user is ... >to do backup is you are db_backupoerator. ... >Tibor Karaszi, SQL Server MVP ... >that this user have 'Sysadmin' permissions, ...
    (microsoft.public.sqlserver.server)
  • Re: backing up to network share issue.
    ... impersonation when it accesses the backup file on behalf of the SQL Server uses that executed the backup ... SQL Server just uses the SQL Server service account when accessing the backup share. ... > As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)
  • Re: Database Backup over the network
    ... The problem is still permissions... ... The file permissions needed for backup are those for the login that sql ... and the permissions are those that SQL Agent uses when the backup ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to Backup on Network
    ... service accoutn from the 'Local System' account to a specific account. ... I like to log in to the SQL server console as the service account to test ... > The operating system on which my SQL Server 2000 is there is Windows 2000> Server while i want to take the backup on another computer on network which> also has same operating system. ...
    (microsoft.public.sqlserver.security)
  • Re: Backing up database on a network machine
    ... You cant see the network drives. ... You Should start SQL server using Domain user who got access to remote ... Now you can execute the Backup script with UNC path ...
    (microsoft.public.sqlserver.msde)