I just experienced this issue as well. I have a job that runs a database backup as the first step. There are several steps after that to do...

I too appreciated this post. This is exactly the information I needed to provide our Network group support for an AD 2008 upgrade. We still have a single...

Sorry to jump on someone else's post, but this is the exact information I"m looking for related to encryption and mirroring.

Based on your post, if my principal database fails and...

Try checking the master database. We sometimes store procedures or functions at that level in order to make them available to all databases without recreating them at the database...

Hi Eddie,

Thank you again. You've been a tremendous help.

I have a follow up question related to certificate effective and expiration dates.

When we created the certificates on all the test databases, we did not enter those dates, so they...

Thanks Eddie. Your explanation makes perfect sense, because we didn't see this error until our test scenario of restoring a database on one server with a backup file from...

Hi Eddie,

First, thank you for the link. I was not using the KEY_SOURCE or IDENTITY_VALUE values when creating my Symmetric Key. Once I utilized those keywords I was...

We are facing this exact same issue. We are in the development process of using column-level encryption in SQL Server 2005 SP3. We have a production server on...

George: "I would have flat file copies of all the system databases to speed up the recovery process, especially mssqlsytemresource."

kwilt: Sorry to step in on someone else's post...

We definitely need to rework the process that is causing this problem. It is being run in batches, but I think even then the batches are too large.

The bigger...

You are a genius! (Or I wasn't thinking--too much pressure?)

I just ran a transaction log backup onto a different drive that DID have disk space...once the backup completed i...

More info: The process was running as a job, which has failed due to insufficient disk space. I again tried the SHRINKFILE commands with no results. The...

I know what is causing the file to grow; and there are still open transactions as the process is still running. If I ask the user to terminate the...

Ok, I've tried both approaches (attach through the wizard, and running the recommended checkprimaryfile command.)

In both cases, I receive this error:

CREATE FILE encountered operating system error 3(The system cannot find...