What is the exact script that is running to backup the log?

Click the 'Edit Subscriptions' link (top right). There you can select and remove whichever subscriptions you like.

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic892583-162-1.aspx

If you want to take it to the PASS board, have a chat first with Kevin Kline (I know he's not on the board any longer). He was involved last...

Are you absolutely sure? Did you check the SQL error log?

Full recovery and no log backups will result in a transaction...

WayneS (3/29/2010)

---

Okay, I did a little bit of a search to find lists of revoked MVPs. Where do...

john.arnott (3/29/2010)

---

To her, the Milanese are aloof. To her, since in her experience there are more white men working with MS-SQL, everyone participating in that conversation is a "white...

aka SQL 2008 R2 early release edition. 😀

That's from replying late at night.......

Ok, great.

Were there any log backups taken between the time of the full backup and the time that the mdf was deleted?

Were there any explicit log truncations? (switch to simple...

Yes, but it's not date-based.

SQL Server 2005 does not support compatibility level 65 (SQL Server 6.5)

SQL Server 2008 does not support compatibility level 70 (SQL Server 7)

p.s. Please in future...

That may well...

I'm not asking what the backup was.

What recovery model was the database in? Simple, bulk logged or full recovery?

What is the order of columns in the existing index? Post the index's definition.

First and most important question.

Was the database in full recovery model?

SQL doesn't keep historical logs for this kind of thing by default. If you did not have a trace running at the time, there's no way to find out who...