Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic626594-1291-1.aspx

Or zipped and attached, which I personally prefer as...

Jeffrey Williams (12/29/2008)

---

Gail - I have to make sure I remember this link. I see this issue so often now that it would just be easier to link to...

Please post in the correct forum in the future. If you post in the wrong forum, people are...

Alos you need to enable the traceflag globally. If you just do TRACEON(1204) then it's only active for that session, which means you'll never see a deadlock graph as it's...

prasad (12/29/2008)

---

By mistake we replace the actual data with old data by using sql import / export. Unfortunately we dont have the backup also. Is there anyway we can recover...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic626488-9-1.aspx

Kerry Tyler (12/29/2008)

---

There's just too much general admin/development functions and wisdom that apply across versions that may get lost on someone who only reads, say the 2005 forum, because it's...

The IO warnings are just saying that you're overloading the IO system and the latency is getting very, very high.

Is the second sp_spaceused that you posted from the processcontrol table?...

I can see one potential problem right away. Activity_id in the journal table is a varchar(50), but in the query you're joining that to a decimal. That's going to cause...

I hate...

And read through this - http://www.sqlservercentral.com/articles/64582/

Access doesn't have a query analyser. There's the query design too inside Access, but that's all I know of for it.

Maybe. But if all you're doing is changing the temp...

ALZDBA (12/28/2008)

---

GilaMonster (12/28/2008)

---

Unfortunately, it's not the image/text pages that are damaged. The checkDB output points to 4 pages of index 0 (the heap) that are the ones with problems. If...