Backup Database to UNC path

From: Curt Spanburgh (cspanburgh@scg.net)
Date: 03/12/03 

From: "Curt Spanburgh" <cspanburgh@scg.net>
Date: Tue, 11 Mar 2003 15:07:56 -0800

I believe the script will fail. You need to create the
device object and have the same access rights as the SQL
Server service on both machines.

>-----Original Message-----
>EXECUTE master.dbo.xp_sqlmaint N'-PlanID 9BDC8D29-A153-
>4F46-AF6D-30BBCABED9FA -Rpt "F:\BACKUP\PLANNAME
>MAINTENANCE PLAN4.txt" -DelTxtRpt 1WEEKS -WriteHistory -
>VrfyBackup -BkUpMedia DISK -BkUpDB "\\X.X.X.X\ABC\temp" -
>DelBkUps 1DAYS -BkExt "BAK"'
>
>I am trying to backup a database to a UNC via IP and
share
>name. Can I put the login credentials in this script, if
>so, what is the correct syntax and where in the script
>should it be placed?
>.
>

Relevant Pages

  • Re: Problem starting process with WMI, when running vbs as service!
    ... cause when you connect to Windows 2000 Machines, ... It only fails when i run the script from a service with srvany.exe. ... There is no connection to SQL from the different machines, ...
    (microsoft.public.scripting.vbscript)
  • Re: Vista hosting XPe tools/db
    ... Are you running this script on the machine that actually has the SQL server ... machine hosting the database. ... i don't know if you can install a second instance of SQL ...
    (microsoft.public.windowsxp.embedded)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: Vista hosting XPe tools/db
    ... here's an alternative script using the Microsoft ADO as ... opposed to the SQL DMO - this should allow this script to work ... Microsoft Windows XP Embedded Test Team ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windowsxp.embedded)
Quantcast