I'm going to make the presumption that the command you gave is in a batch file being called. That said, it's an easy fix.

Change this:

forfiles -p "C:\SSISFILES\Log\" -s -m...

Well, I found something on the MSDN forums that seems to indicate the only option would be a 3rd party backup utility...

Database encryption functionality retired in SQL 2012?[/url]

Obviously, not the...

Precrime

RBarryYoung (9/12/2012)

GSquared (9/12/2012)

RBarryYoung (9/12/2012)

Well, I may have over-reacted. I am trying to an IRS download directory (http://www.irs.gov/pub/irs-soi) but a I cannot get a connection. I don't think it...

Montego Bay

Wherewolf?

Thanks Lynn.

😉

hunchback

Thanks. I guess what was throwing me was, I would have expected to still be able to logon to the SQL using one of the existing local Windows users.

Jason

Have you considered using Powershell? I'm presuming you have it on the server, so you could craft a Powershell script to grab the file(s), then unzip them. Once...

Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...

Even if it is something that a seasoned DBA (not me!)...

I would have two dream machines, one for work use, and one for personal use...

My work box would just be a desktop, support 2+ monitors, LOTS of RAM and a...

A DOS batch file run with Windows Task Scheduler.

Here's one I came up with, it does require that you have pkzip / pkzipc / pkunzip somewhere in your path, though....

Once more, thank you. I hadn't thought about what would be required to restore the DB (and still be able to access the encrypted data) until after your post.

With...

OK, so Express can for sure encrypt by passphrase, so I'm expecting it will work by certificate as well.

Yup, it does work by certificates as well...

Once more, thank you!

Jason A.