Expiredate isn't a delete. It allows rewriting of the file. If you put multiple backups in ONE file. meaning you have sales.bak and it has backups for last night and...

checkdb, which should be regularly run, and error log checks (again, regularly scanned), will alert you.

What you do depends on what you find. Good suggestions above.

What's your xcopy string? It should run from the command line fine.

Also, how are you executing xcopy?

You'd have to write something. I had friend that built a "check" into the app to look for changes when it starts (or users click something).

The minutiae of how to...

Not yet. The list is at http://www.sqlsaturday.com. Feel free to bring this up in your user group and see if people will put one together.

Bob,

Good points and I'll try to remember to clarify a bit. I usually do post a "why do you want this. Perhaps we have another solution" with my query.

I don't have the list handy, but Configuration Manager grants the rights needed (folders/files/user rights) for the service account.

Always ask what they want to do. They often don't know the problem.

Third vote for Jeff/Gail

http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart3/525/

SQLPackager from Red Gate works as well

Change this in Configuration manager, not control panel, and you should be fine.

I'd go with auditing. Trace/Profiler could miss something if it gets stopped, or isn't started when the server reboots

I'd go with Gus' advice.

create new table

begin tran

select into from old table (minus GUID)

drop old table

rename new table

commit

What you would need to do is serialize these. So backup, then script the move, then backup next one, etc. You'd need validation to be sure that the backup was...

Are you executing through BIDS? sp_start_job? How?