Lowell (7/21/2009)

---

maybe one of the articles required registration on another site, so you duplicated the same email for registration for that article? check your cookies or firefoxes saved passwords...see if...

Very well, thank you. The first PC that I built for myself was an 8086 (XT)....

The only thing I can see at the moment that looks suspect is that all of your indexes have been set to not auto update stats. Is there a reason...

Glad to hear that you've resolved the problem.

Ankur Bajaj (7/21/2009)

---

Disabling access is not an option as there might be 100s of users,anyone of whom might run the backup command.

Heres the solution I have tested and which is...

JohnSQLServerCentral (7/21/2009)

---

Well I know SQLServerCentral gave my email address to techtarget and techtargetlists. I know this because the email address I used is JohnSQLServerCentral @ [my company domain]....

Kit G (7/21/2009)

---

I'm semi-interested in Angels and Demons because I'm curious about various Catholic Church conspiracy/occult/whatever theories. They make for good stories. Secret societies, buried occult mysteries, the...

Doing that the transaction remains open, holding locks, until the connection is closed, at which point the transaction will rollback. It is bad practice, and it's got some subtle side...

Mainstream support for SQL 2000 ended last year August. Extended support (if you're paying for it) ends in 2013

Saw Startrek. Loved it. Good story, emotional scenes (Spock's mother), tension, explosions, etc. What really clinched it for me was all the little bits, sayings, mannerisms that linked back to...

You should still acknowledge that what you're posting is not your own...

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/Topic756507-148-1.aspx

Steps 2 and 6 are not required as, once you've backed up the tail of the log, you can restore over the existing database.

Problem is that the original poster said...

Not sure I understand what you want.

If you want the date of 5 days ago, this will get it. If you want something else, please explain further what it is...

Great, now please read through this - Managing Transaction Logs[/url]