They wont be able to read the backup file in its raw format, but if they have also intercepted the master key, database key, certificates etc all they need to...

Do you have any of the following rights?

Membership in the db_securityadmin or db_owner fixed database role.

Membership in the role that owns the role.

ALTER ANY ROLE permission or ALTER permission on...

The clustered index is the table.

So whatever you insert into the table is stored in the clustered index.

You insert the value 10, the clustered index value is 10

Backup compression is lossless (IIRC) so someone with knowledge of compression could revert the compression algorithm.

Then again encryption is also reversible, you will have backups of your certs / keys...

What do you define as confidential information?

Things like Red-Gate SQL Compare can read a diff backup to get the schema, unsure on Data Compare

http://documentation.red-gate.com/display/SC11/Working+with+backups

SQL Compare can retrieve the schema from...

Whoops, oversight on my part I do appologise.

http://technologycraftsmen.net/blog/2010/10/19/alphanumeric-sorting-in-mssql/ has a function which will do it

SELECT activityName

FROM #Activities

ORDER BY

master.[dbo].[fn_CreateAlphanumericSortValue] (activityName,1)

!!WINNING!! (in my best Charlie Sheen impression)

one armed

Something like this?

SELECT activityName

FROM #Activities

ORDER BY

Case When IsNumeric(activityName) = 1 then Right(Replicate('0',21) + activityName, 20)

When IsNumeric(activityName) = 0 then...

1. has a database about 100gigs ish, but the transaction log file are about 5-10kb, I want to log ship from prime location to secondary, will I run into issues...

villain

otomatopeia

What does the Windows event log say?

Why not use logshipping and set the restore job to run once a day?

Ed Wagner (9/22/2015)

Cane