Markus (7/30/2014)
SQLRNNR (7/30/2014)
The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.Also worth comparing with them if the database version (down to CU) is exactly the same as yours.
I will ask about encryption... I know they are on SQL2008R2 SP2 and we are on SP1.
Both of those would be issues.
If they are using TDE, you will not be able to restore that backup without the certificate they used to encrypt the database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events