Also all backups are encrypted, as well as the mdf and ldf files, and any ndf if you have multiple filegroups.

If you want to restore your database to another server...

Hey Wayne,

Great article, I was wondering what the resolution to the problem you guys encountered was. I've really enjoyed reading Paul's blog...

LOL that is very true, I always get asked questions about printers and copiers being a "tech" guy even though that is not my area at all. Yesterday I...

....sometimes it is the most obvious thing. No you were right on I had copied my scripts into word and for some reason TDP was copied instead of TCP,...

Hi Mr. Davis,

I'm running into a repeatable error on one of my mirroring sessions. They are 2 SQL 2008 SP1 Servers, using Transparent Data Encryption, running...

Are you using Transparent Data Encryption?

I intially had gotten Mirroring working with it, but had an error, and have not been able to fix it since and I...

if you look at the dates this is a very old thread dating back to 2004, LOL as a matter of fact so old it was posted 2 days before...

Agreed, that is a very good point. I figure the hardware counters would be a good way to say problem here or not here.

and certianly before attempting any hotfix,...

http://support.microsoft.com/kb/925419/%5B/url%5D

also not sure what your build number is, but I found this the other day, not quite the same, but it was one of the SQL 2000...

if you open up perfmon and start a counter,

add the drives with the DB data and log file Physical Disk counter Avg. Disk Queue Length

to See if the...

What is the build version of SQL 2000 that you are running?

If you go to SQL Query Analyzer and type in SELECT @@VERSION it should be in that string

I had a friend once help me get a job interview. He met me at the airport so I had a friendly face to see before I went and...

Well I wish I had a more defined answer, but after the reboot for the ports it is now listed. I can see 100 compatibility level........

Ty for all the...

SSMS 2008, I believe you should get an error if you use SSMS 2005 trying to connect to a SQL 2008.

😀 no worries it always helps to check the...

Yep, I look a the server and I see that it is build 10.0.2531, and if i run sp_dbcmptlevel <dbname> I get as a return.

"The current compatibility level is 100."

however...