After our Daily backups are complete, I would like Sql to Open a Zip File.
Is their a command to do this within SQL?
EddieThere's no direct SQL command to open a zip file. What do you want SQL Serve
r to do with the zip
file? What does the zip file contain? Do you want to unzip the zip file and
extract the files in it?
In any event, you can use the command-line version of winzip, called wzzip,
from xp_cmdshell. If you
want to compress your backups, there are some 3:rd party apps that does this
:
http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:4A434EBC-738C-47BE-8C90-20883B346517@.microsoft.com...
> After our Daily backups are complete, I would like Sql to Open a Zip File.
> Is their a command to do this within SQL?
> --
> Eddie
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment