Re: Backing up database on a network machine

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/29/04

  • Next message: Chad Harris: "*How MSFT *Deliberately, Arrogantly, Egregiously, and Totally* Fails to Support Office, MSDE2000 in BCM*" 
    Date: Sat, 29 May 2004 22:16:10 +0530

    Hi,

    You cant see the network drives. Please perform the below steps to take the
    backup remotely.

    There are Few Pre requisites to do this;

    1. Should have share in the remote machine
    2. You Should start SQL server using Domain user who got access to remote
    machine Share
    3. If you need to schedule this as a job then SQL Agent should use the same
    Domain user in which SQL server was started
    4. Restart the services

    Now you can execute the Backup script with UNC path

    BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
    init

    Note:

    Backup to remote machine will not work if you start SQL server using Local
    system account

    Thanks
    Hari
    MCDBA

    "whynot" <anonymous@discussions.microsoft.com> wrote in message
    news:DD4A5442-E21F-4AC0-B62F-34CEC954F4FA@microsoft.com...
    > Hi,
    >
    > I have SQL Server 2000 installed on my machine. My machine can see other
    machines which have sharable drives in the network neighbourhood. All the
    machines are win xp and it is a simple peer to peer network. When I try to
    backup my database, I can see only my local drives in the path selection
    dialog box. I cannot even see the network machines. I ran the server
    network utility and had 'Named Pipes', 'TCP/IP', 'NWLink IPX/SPX' protocols
    enabled.
    >
    > Why is this happening. Any ideas are appreciated.
    >
    > Thanks

  • Next message: Chad Harris: "*How MSFT *Deliberately, Arrogantly, Egregiously, and Totally* Fails to Support Office, MSDE2000 in BCM*"

    Relevant Pages

    • 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: 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: Backup into another machine.
      ... but there are Few Pre requisites to do backup ... You Should start SQL server using Domain user who got access to remote ... > Backup to remote machine will not work if you start SQL server using Local ...
      (microsoft.public.sqlserver.clients)
    • Re: Backup into another machine.
      ... but there are Few Pre requisites to do backup remotely; ... You Should start SQL server using Domain user who got access to remote ... Backup to remote machine will not work if you start SQL server using Local ...
      (microsoft.public.sqlserver.clients)
    • Re: backing up to network share issue.
      ... As Tibor stated, this is not an SQL Server issue, it is a network ... The SQL login that is accessing the MSDE instance is not ... a factor in whether the process doing the backup has the correct permissions ...
      (microsoft.public.sqlserver.msde)
    Loading