@cmd should be

'"C:\Program files"\WinZip\winzip32.exe" -a "\\Dell\Tessitura\Source\sso_pacingdata.zip" "\\Dell\Tessitura\Source\sso_pacingdata.txt"'

Also try executing the output of select @cmd from the command prompt. This should help you troubleshoot.

Hi Varsha,

First make a note of the windows login which is starting SQL Server service (from the SQL Server Configuration Window)

Then logon to the server on which you need to...

You need to have permissions on the folder. You can grant permissions to your account/the account with which the SQL Server is starting, as in this screenshot.

This article has more information and example on how to use TIMESTAMP datatype.

Before running the RESTORE you can verify the correct logical/physical names of the database files inside the backup file. For this purpose you use RESTORE FILELISTONLY command.

e.g. RESTORE FILELISTONLY...

Please ensure that the SQL Server startup account has sufficient privileges on the Public Network share.

Alternatively, you can take the backup locally to the disk and then copy it...

If you run the same command in Command Prompt does it complete successfully? If yes, then the SQL Server service account might not have access to the path where the...

Here is an article posted few days back. You may find this useful.

If Log shipping backup job...

May not be a good question. Was the query running when you were executing KILL?

Please go through this site. It answers all the above questions.

Does DBCC CHECKDB on master report any errors?

GilaMonster (11/30/2010)

I for one am not helping out any further. I won't be a part to what looks unethical and maybe even illegal. Honestly, if I were in your shoes...

If your question is how to take the backup of a database on a Public Network, it is the same as earlier. In stead of ServerB in the server name...

This error message is because you have selected Authentication from SQL Server Login. Please change it to Windows Only.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2ad7cf73-695f-4770-bc7b-f68ed6281649/[/url]

http://www.sqlservercentral.com/Forums/Topic478323-359-1.aspx

Since you are using SQL Server 2005, it would be better to...