Hi Evgeny. Sorry you had problems at the testing center! The two entries for the test indicates that they had a problem getting the exam started at the beginning. When...

L' Eomot Inversé (9/16/2012)

---

Anyway, you've already made in clear when responding to Gail that you aren't interested in looking into any references that are provided for you, so why do...

Sergiy (9/16/2012)

---

Still not clear why do you think so.

If SQL Server performs the same...

prettsons (9/9/2012)

---

First check SQL Server error log ?

The error means: You have at least one corrupt page in the database that's being hit during recovery. This means you can't access...

The error message indicates that. As opc.three said, CheckDB creates a database snapshot internally. When it creates a snapshot, it has to run crash recovery on the snapshot to ensure...

That would seem to be a failure creating the database snapshot that DBCC uses. You need to investigate why the database snapshot is failing.

You should open a case with Microsoft PSS.

Found these 2 relevant Connect items and both point to contacting PSS: http://connect.microsoft.com/SQLServer/feedback/details/529716/problem-with-cannot-find-database-id-0-the-database-may-be-offline and http://connect.microsoft.com/SQLServer/feedback/details/694675/could-not-find-database-id-0-name-dbname-the-database-may-be-offline-wait-a-few-minutes-and-try-again

History is stored in msdb database in msdb.dbo.dbm_monitor_data. You don't need to delete the history. The monitor job will take care of that for you.

What exactly are you trying to find out?

Doesn't sound like a memory leak. You're over-working SQL Agent running linked server queries (which do not use the buffer pool) and it's requiring 3 GB of memory. I would...

saidapurs (9/6/2012)

---

Hi Anand,

Robert is right, change it into run time and one more plus point is incase your Principal server will crash or else updated...

To be a mirror or principal partner, the endpoint's role has to be either "partner" or "all". Both can be "partner, both can be "all" or one can be "partner"...

More info please. How are you determining that CDC stops capturing changes?

It's just a SQL job that runs. If you want to change the run time, edit the SQL job to run a different frequency. The performance impact is negligible.

When a backup fails to complete, 2 error messages are returned. The one you posted above is the 2nd error message that gets returned. You need to look in the...