[/quote]Then set it to Simple recovery in the meantime.[/quote]

[/quote]

For the actual used space in the log you can run this :

dbcc sqlperf(logspace)

That'll give you the hd used space and...

homebrew01 (10/7/2010)

---

Maybe I missed it, but why haven't you put t-log backups in place as suggested ? If it's a production...

[/quote]

Here's an easy solution. Move to simple recevory and send this thread as backup.

You won't find much better advice than whatever Gail can give you, or derreck, or mine.

If...

GilaMonster (10/6/2010)

---

MostInterestingMan (10/6/2010)

---

With the recovery model set at FULL (USING SIMPLE IS NOT AN OPTION) and no log backup being done what is the recommended best practice on managing the...

MostInterestingMan (10/6/2010)

---

Ninja's_RGR'us (10/6/2010)

---

MostInterestingMan (10/6/2010)

---

The databases are small now and I have not monitor the "normal"...

Ninja's_RGR'us (10/6/2010)

---

MostInterestingMan (10/6/2010)

---

The databases are small now and I have not monitor the "normal" daily...

Derrick Smith (10/6/2010)

---

Why are you using full if you don't plan on taking transaction log backups?

I realize you said it's a requirement, but why? That sounds like it was a...

The databases are small now and I have not monitor the "normal" daily log growth....

MostInterestingMan (10/1/2010)

---

Alvin Ramard (10/1/2010)

---

Is there anything that changes the properties of the data source at run time? Check the expressions. It's possible the source gets changed at run...

There...

That is the same thought I had...it is strange.

I just added...

Alvin thanks for your reply. Yes the preview works.

MostInterestingMan (8/24/2010)

---

DavidZahner (8/24/2010)

---

The error is indicating it is using Named Pipes so be sure that protocol is enabled in Configuration Manager. You also mention connecting via Management Studio, but if...

a