If you have no backup then you are going to have to take the database into single user mode and run CheckDB with the repair_allow_data_loss option. This will lose data!...

Ok, the Disk queue length reported by perfmon is correct. There's no question there. The problem is the traditional interpretation of that counter is that if it exceeds 2 per...

Sentech. I haven't heard about similar problems from iBurst or Neotel, but have no experience with them.

My contract is finally up in March (cancellation fees are very high, that's why...

The clustered index is the table. A clustered index has, at the leaf level, the actual data pages of the table and SQL will do it's best, at time of...

I haven't ever heard that. Is that your opinion or are you asking for clarification of something you're read? If the former, why do you think that, if the latter,...

K. Brian Kelley (8/26/2009)

---

Lynn Pettis (8/26/2009)

---

So, what was the question and how did you handle it? I've just started ignoring requests for help sent via PM. I don't...

glu (8/26/2009)

---

This is the same query of different executions, and return the same numebr of rows, thus network load is the same. This scenario has been repeated many times and...

glu (8/26/2009)

---

What puzzles me is that, take one table as example, display of SET STATISTICS IO ON shows "logical reads 62832, physical reads 55, read-ahead reads 1190" in the case...

Expanding a bit on Steve's post.

Restore the full WITH NORECOVERY

Restore the latest differential WITH NOERCOVERY. You don't need both differentials

Restore all the log backups, in sequence, starting with the...

Amit Singh (8/26/2009)

---

Once restored ... shrink the Data and log files to release free space ..... then take another full backup of this shrinked databse and use that to restire...

So the files in total are 3.2GB,...

It's not running CheckDB. It's saying when CheckDB last ran successfully.

08/05/2009 06:41:00,spid58,Unknown,CHECKDB...

Luke L (8/26/2009)

---

GilaMonster (8/26/2009)

---

Yay. ISP down, again. This time their main basestation is down, affecting every single one of their customers. It's been down since around 3am this morning, eta...

Yay. ISP down, again. This time their main basestation is down, affecting every single one of their customers. It's been down since around 3am this morning, eta until repaired, unknown.

And...

Duplicate post. No replies to this thread please.

Direct replies to http://www.sqlservercentral.com/Forums/Topic777331-146-1.aspx