This is only documented in cases where there is no witness. Not possible (supposedly) if using a witness.

What happened in between? Was there a failover triggered or an outage or...

Please describe in detail what happened.

Mirroring supports database snapshots in Enterprise/Datacenter Edition. You can take a snapshot of the mirror database and provide a read-only point-in-time copy of the database for reporting purposes.

Database mirroring is...

Just to reiterate, All I'm all, good article. Don't let my comments discourage you. Keep writing!!

Congrats on writing posting your first article!! I think it's a pretty good first article. There are a few points I'd like to clarify just to make sure the readers...

Is this what you are looking for?

SELECT PRODUCTCATEGORY.IDPRODUCT,

PRODUCTCATEGORY.IDFIELD,

SQUERYTABLECATEGORY.NAMECATEGORY,

SQUERYTABLETYPE.NAMETYPE,

SQUERYTABLELINE.NAMELINE,

SQUERYTABLEQUALITY.NAMEQUALITY,

SQUERYTABLESIZE.NAMESIZEFROMTABLECONF,

CATEGORY.NAMEDESCRIPTION AS NAMECATEGORY,

TYPE.NAMEDESCRIPTION AS NAMETYPE

LEFT JOIN CONFIGURATION AS CATEGORY

ON PRODUCTCATEGORY.IDFIELD = CATEGORY.IDFIELD

AND PRODUCTCATEGORY.IDCATEGORY = CATEGORY.IDCATEGORY

And (Category.IDFIELD = 1

Or Category.IDFIELD Is...

When switching to simple recovery model, you also lose the ability to perform file or filegroup or page level restores. For example, if I had a corrupted page in a...

Run DBCC CheckDB With EstimateOnly and verify that you have enough tempDB space. EstimateOnly will tell you how much tempDB space it estimates will be needed.

If not enough space, try...

K Foster (2/23/2011)

---

Very informative article. In the section entitled 'Checkpoint' you say 'If the checkpoint log reuse wait appears frequently...'. Where would I look to check if this is appearing...

Just read everything Gail has written, and you'll be a better DBA for it.

ceso (2/21/2011)

---

Hi Gail, Great article. However i have 1 question; Are you saying that when one issue the command backup log db_name with truncate_only it backs up the active portion...

david.howell (2/21/2011)

---

Thanks for the very informative article.

Running the first query I see Simple Recovery model and 'ACTIVE_TRANSACTION'

However, running DBCC OPENTRAN report "No active open transactions."

This doesn't seem to add up....

Great article Gail!!

Log shipping is not expecting there to be a 3rd server. Most people store the backups local on the primary server. Generally, the expectation is that the directory with the...

You could do that, but I wouldn't recommend it. The most important step in the process is creating the log backup because you may need to use it in a...