SQL Job question

From: "Chris Hall" <someone@xxxxxxxxxxxxx>
Date: Thu, 22 Mar 2007 17:12:00 -0400

Greetings,

I'm a complete nub with SQL and have a question. I haven't been able to find
any resoures on this....We have an application that uses SQL 2000 on the
backend. I'm trying to setup an automated way to backup a database, then zip
that database up. The final step would be to set a scheduled task (windows
task mgr) to ftp the zipped file to an ftp server. The server is running
Windows Server 2003, the SQL version is 2000. Here's the transact-sql code
I'm using to:

DECLARE @bkFile varchar (75)
DECLARE @str nvarchar (300)
SET @bkFile='E:\Data\MSSQL\BACKUP\PPSSQLBU.bak'
BACKUP DATABASE [WinFMSQL] TO DISK = @bkFile WITH INIT, NAME = N'WinFM Full
Backup', STATS = 10, DESCRIPTION = N'WinFM DB Full Backup'
SET @str = '"C:\Program Files\7-Zip\7zFM.exe"
E:\Data\MSSQL\BACKUP\zip\PPSSQL.zip E:\Data\MSSQL\BACKUP\PPSSQLBU.bak'
EXEC xp_cmdshell @str

The backup kicks off and complete's fine, however, the file doesn't get
zipped. The log file and event viewer offers little information.

Thanks for your suggestions,
Chris

.

Follow-Ups:
- Re: SQL Job question
  - From: Andrew J. Kelly

Prev by Date: Re: SQL Server 2005 SP2 fails in upgrading Database service
Next by Date: Re: SQL Server 2005 SP2 fails in upgrading Database service
Previous by thread: SQL server does not exist or access is denied
Next by thread: Re: SQL Job question
Index(es):
- Date
- Thread

Relevant Pages

Re: SBS2003, NTBackup-Fehler
... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
(microsoft.public.de.german.backoffice.smallbiz)
RE: Backups have Shadow Copy Problems
... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
(microsoft.public.windows.server.sbs)
Re: Scheduled Backup for SQL Database
... Look in the SQL Server log too, ... Need smaller SQL2K backup files? ... >>Need smaller SQL2K backup files? ...
(microsoft.public.sqlserver.server)
SQL/ MS 2003 server backups/restores
... I'm a bit confused on the backup necessary for my SQL server running on MS ... system state, OS etc, and another for my SQL databases. ...
(microsoft.public.sqlserver.server)
Re: Backup erros
... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
(microsoft.public.windows.server.sbs)