i'm not ignoring the answers. I specifically take copy_only backups because I don't want to interfere with log backups! I think there's some wires crossed here.

I don't get it. Maybe my brain's given up with it being Friday.

We take a regular full database backup every day at 10pm. Throughout the day, we take...

cool - that's the answer I was looking for. Cheers,

george sibbald (11/25/2011)

---

use the 'from device' radio button and navigate to the location of your backup to select the backup you want to restore.

Note just in case - you only...

My brain hurts...

good ideas - I'll start on that now...

on my sandpit database it looks to be. I'll have to wait for the app support team to tell me how much trade data I've inadvertently deleted before celebrating...

thanks for your help

let someone else run it and pretend you never had anything to do with it?

Hi,

Point taken about batch size - i'll change this.

So, I've come up with this. How's it look? Anything stand out as being rubbish? It seems to go...

Hi,

This is one of many attempts... It generates valid SQL okay, but it doesn't seem (based on the printed output) to be looping through the table until all qualifying records...

sjimmo (11/1/2011)

---

You ALL failed. 😉

I have gone back and read this entire thread. At times I fond it to be humerous. Not one has mentioned the templates that are available...

We allow users to access the database through the designated application, for which they are in an AD group with limited permissions, but we don't want those same users accessing...

http://blogs.msdn.com/b/sql_protocols/archive/2005/10/12/479871.aspx

Actually, just figured it out. SQL Server's picking up the connection as 'Microsoft Data Access Components'. Our login trigger's screening applications like '%ACCESS%'...

thanks for looking.. 😀