Re: How to backup for network drive

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

1) Make sure SQL Service is running under a domain account
2) Use a UNC path, not a mapped drive e.g.
BACKUP DATABASE DB1 TO DISK='\\OTHERSERVER\BACKUPS\DB1.BAK'
3) Make sure the SQL Service account has write permisions for the
destination share

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips


<iletisim@xxxxxxxxxxxxxxxx> wrote in message
news:1176121238.608252.187370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
My SQL server 2000 standart and SP 4 instaled.
I want ta database backup destination network map drive. But not
visible

How to correct this problem ?

Thank you.



.

Relevant Pages

  • Re: Log shipping
    ... Using a domain account ... would probably make it easier to set up log shipping. ... Keith ... > SQL Service & Agent services - do they have to use a domain account to ...
    (microsoft.public.sqlserver.setup)
  • Log shipping
    ... I am looknig to configure log shipping however I am not sure about the ... SQL Service & Agent services - do they have to use a domain account to ...
    (microsoft.public.sqlserver.setup)
  • Re: DB backup to UNC path failing
    ... it is a better to use Enterprise Mangler to change SQL Service ... > Microsoft SQL Server MVP ... >> No password change but I did notice that the account had modified. ...
    (microsoft.public.sqlserver.clustering)
  • Re: cannot generate sspi context when server in mixed authenticati
    ... Kevin Hill ... Real-world stuff I run across with SQL Server: ... after we switched it to mixed authentication mode. ... find a valid SPN for the SQL Service on the server then it should ...
    (microsoft.public.sqlserver.connect)
  • Problem configuring SQL Server 2000
    ... I had a problem before the setup intallation of SQL Server 2000 into a XP machine was successful. ... I can´t start the SQL service, it raises an error related to the sesion init. ...
    (microsoft.public.sqlserver.server)