If you're loading 1-2 GB a day in the log, I'd shrink the log to 5GB. Space is relatively cheap, and this gives you pad.

You don't need a 140GB log,...

Those are not the...

Jeffrey Williams 3188 (4/22/2013)

---

GilaMonster (4/21/2013)

---

Let's see... what happens when we have a 6-hour full backup duration and a 15 minute data loss SLA and log backups don't run during that...

My thoughts:

If you are updating this once and day, and it's your database, important, but not affecting others, here's what I'd do.

Change the database to simple mode. With updates once...

Brandie Tarvin (4/22/2013)

---

Steve Jones - SSC Editor (4/22/2013)

---

Brandie Tarvin (4/22/2013)

---

Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping...

Brandie Tarvin (4/22/2013)

---

Steve Jones - SSC Editor (4/22/2013)

---

I know Brandie will like this, and perhaps others. My 14yr old asked if he could go to Comicon in Denver with his...

I know Brandie will like this, and perhaps others. My 14yr old asked if he could go to Comicon in Denver with his friends.

Now I'm thinking I might need...

Brandie Tarvin (4/22/2013)

---

Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked to "train" the...

Thanks. I've sent this to our team and we'll discuss it.

Gary Varga (4/22/2013)

---

I also think that we are going to have learn to throw away more data too. This will probably be a rough road in data management. Those of...

patrickmcginnis59 10839 (4/18/2013)

---

I have to admit, I don't like to work under...

There is no such thing as a record number in SQL Server.

You can set an identity property for a column, and it will autoincrement based on settings, but there is...

Eric M Russell (4/18/2013)

---

I was serious about the "employment at-will" contract, if that's an option in your country or state. It can include provisions for things like severance pay or...

It would be great if you posted the solution, in case anyone else has a similar issue.

Kingston Dhasian (4/18/2013)

---

I would help the OP if I feel the person has taken some effort in trying to find answers themselves and is not plain lazy.

I have found numerous...