That's why you take transaction log backups. If you don't backup the transaction log then it will...

Change to Full recovery mode and run transaction log backups. With transaction log backups you can recover to the point just before failure. That is much more acceptable...

You will need to do a full restore.

There are tools that will read the transaction log and some say they can rollback a transaction. I have not successfully rolled...

I learned something today. I am still left wondering how to do it? The documentation is very light on the subject.

[font="Arial Black"]

YES[/font]

Paul White (3/16/2010)

---

Jeff Moden (3/16/2010)

---

Very interesting! Apparently, I've been missing out on some good stuff because that works in 2k and 2k5. Keeping in mind that I don't...

I think this needs a little...

Jeff Moden (3/16/2010)

---

In my eyes, 20GB for such a database is probably ok but a bit large. My suggestion would be to reexamine the underlying methods and, as already...

Windows Server Enterprise edition is a requirement.

tsduke03 (3/16/2010)

---

CirquedeSQLeil (3/16/2010)

---

duke-347723 (3/16/2010)

---

I have a database that I need to move to another server. The server admin is giving me 4 500gb drives. I need to restore...

I think that was a good answer.

Something that worked for me in the past was an 8 file tempdb. I permitted autogrowth at 512MB in each file - for the just in case scenario. ...

duke-347723 (3/16/2010)

---

I have a database that I need to move to another server. The server admin is giving me 4 500gb drives. I need to restore the 1.2...

tstaker (3/16/2010)

---

So what you're saying is around 137 BC she'd be a goddess in...

If it sounds like we are discouraging you, we aren't.

Making the right choice is a difficult one in a position such as yours. It would be an awful situation...