Ohh thanks 🙂

None of the trace flags would not cause anything to Tlog backups. But, to trace deadlock graph why would you want to enable...

No problem, you are Welcome 🙂

Are you not doing any root cause analysis and find out where the problem could be? mostly due...

DataBase Assassin (3/19/2009)

---

A SQL 2008 maintenance job failed for the first time after countless successful runs w/ the following error:

Databases that have a compatibility level of 70 (SQL Server version...

Steve,

Can't access the Interview pages?

have you got Trace flag 1222 enables on your server? If so, enable and it records the dead lock events in the error log.

check out bart's blog and get more...

koteswara kishore K. (3/26/2009)

---

Hi Chris,

Thanks for the update.

My table having indexes, normalization and all other statistics are good.

But we are facing a latency when we are using this...

Nope a Principal and a Mirror always form a pair. so, you cannot have multiple principals to a mirror or multiple mirrors to a principal unlike Log shipping where...

Yes, it is enabled by default, the best way is to create a job to dump the data from the trace.

Check this one out:

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

and this one:

http://www.sqlservercentral.com/scripts/SQL+Trace/65790/

What does it...

raju.tanneeru (3/26/2009)

---

I have two agents jobs for backups, sunday full bkp and rest of the days differential bkp, if i do this 'Shrink' task, will it have any impact on...

I thought you gone through the article. The best way to know issues on your serve is to monitor it.

Abi Chapagai (3/25/2009)

---

Suppose, user complains that it is timed out each...

Can you elaborate your situation so that any one can help please?

dallas13 (3/25/2009)

---

Here is my maintenance task on sql 2005 EE server

1)backup all user databases

2)backup log for all user databases

3)reorganize index

4)rebuild index

5)update statistics

6)cleanup backup history task

this job used to run...