Any reason not to do this from the command line?

You can use this to see what it does:

for %%i IN ( V:\Data_1\*.MDF) DO echo "C:\Program Files\WinZip\WinZip32.exe" -a %%~di%%~pi%%~ni.zip %%i

and this...

Thanks for the script, Vince.  This came in very handy.

One thing to add -- I had a reporting services instance that logged in when the DB went into single user...

Ouch!  Didn't expect to miss this one.  I consider following best practices the same as "Need".  Perhaps rephrasing as "You are running Windows 2003 X64 edition with SQL Server...

Doh!  That was a lucky guess, guess Microsoft activated the link just before Steve got back.   Too bad I didn't guess that luckily on the QoD today.

Jim

Is this related to the September CTP?

http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

Jim C

I love the idea.  Occasionally, I'd like to print a question to ask some of the other DBAs at the water cooler, or refer back to the previous answers if...