Re: How to backup/restore entire database in easiest way?

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

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/15/05 

Date: Fri, 14 Jan 2005 22:45:45 -0500

The backup command (or most any TSQL commands for that matter) are always
executed on the server regardless of where you initiated the command. If
you want the backup file to be placed on a machine other than the server you
can use a UNC path (\\YourMachine\SharedFolder\Filename) to place it there.
But the backup command is always executed under the context of the account
that SQL Server itself runs under. By default that is the Local System
account and it has no rights to any remote share so you would have to run
SQL Server under a Domain account with rights to that share to do that. 

-- 
Andrew J. Kelly  SQL MVP
"Do Quyet Tien" <tienonsoftware@yahoo.com> wrote in message 
news:eITEapq%23EHA.2804@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I'm found this sample for BACKUP DATABASE statement in SQL Server 2000 
> Book
> Online, but is seemed that only save file to server. How can I save backup
> file to local computer? or there is other way as easy as this statement 
> for
> backup/restore database?
>
> -- Create a logical backup device for the full MyNwind backup.
> USE master
> EXEC sp_addumpdevice 'disk', 'MyNwind_1',
>   DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
>
> -- Back up the full MyNwind database.
> BACKUP DATABASE MyNwind TO MyNwind_1
>
> Thanks,
> Tien,
>
>

Relevant Pages

  • RE: SBS Back up Failure
    ... attached the log and report from yesterday's backup also. ... One or more components of Small Business Server Backup failed. ... recommended that you review errors in the Event log related to the service. ... Notifications task in the Server Management Monitoring and Reporting taskpad. ...
    (microsoft.public.windows.server.sbs)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... Well, it turns out the RDP connection dropping issue won't go away, ... level to the server in the office may have an affect on the issue. ... I just remembered I also re-installed RDP Client V6 last night as ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... I left the connection sit idle and checked back in an hour. ... server and browsed around for a few minutes. ... it would seem that there is still some issue with the V6 RDP ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: SCO 5.0.7 MP5 network hung up
    ... The last time I had a problem with streams on 5.0.7 it was caused by ... Is Samba in the mix? ... own directory, such as '/var/fetch', so it can be left out of backup ... "floating" IP address and be served by the backup server. ...
    (comp.unix.sco.misc)
  • Re: Clustered SQL servers in DR Hotsite
    ... the initial synch involves taking a full backup. ... SQL Server MVP ... I have to bring up a second set of clustered SQL servers at a DR Hotsite. ...
    (microsoft.public.sqlserver.clustering)