I don't use the spaceused report so am unaccustomed to the those issues but that is good to know.

In the case of the second issue, generally a re-index will fix...

ricardo_chicas (5/23/2014)

---

Thanks you!!!

It was a system table related to service...

Run the script I have on this page and let us know if it reports tables with large space use

http://jasonbrimhall.info/2014/03/28/table-space-updated-again/

Couple of things...

Where did you get SP 10? 😉

Have you rebuilt indexes since truncating?

Did you have any blobs in those tables that you reduced data?

Based on the errors, it appears you have something/someone trying to trunc the log.

the steps you listed are unnecessary to resolve the issue.

Find what is truncating the log and make...

Raghavendra Mudugal (5/23/2014)

---

SQLRNNR (5/23/2014)

---

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can...

Igor Micev (5/23/2014)

---

SQLRNNR (5/23/2014)

---

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can...

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. ...

GilaMonster (5/23/2014)

---

SQLRNNR (5/23/2014)

---

GilaMonster (5/23/2014)

---

Steve, can anything be done about shrills like this:

http://www.sqlservercentral.com/Forums/FindPost1573887.aspx

He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to...

Jeff Moden (5/23/2014)

---

BWFC (5/23/2014)

---

Ed Wagner (5/23/2014)

---

Koen Verbeeck (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a...

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is...

Grant Fritchey (5/23/2014)

---

I'd also suggest going with the schema.

Or, if you have to name the tables, I'd go with naming them MyTableStaging or something like that instead of using old...

GilaMonster (5/23/2014)

---

Steve, can anything be done about shrills like this:

http://www.sqlservercentral.com/Forums/FindPost1573887.aspx

He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB...

PotatoHead

is this just the case when running these backups via maintenance plan?

What happens when running a tsql script backup?

Any chance the recovery model is getting switched to simple and back...