• SQLRNNR (7/30/2014)


    Markus (7/30/2014)


    SQLRNNR (7/30/2014)


    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.

    I have never had a service pack difference be an issue with restoring a database.

    TDE.... Understand... however....

    I have successfully restored their backup TO the NAS device... so... makes me think both of these are not factors.

    When you say you restored it to the NAS device, what do you mean? You were able to place the backup file on the NAS device, or you restored the database into a SQL Server instance that accesses the NAS device for storage?

    Yes. We cannot restore from the NAS backup to our back end storage. I have also tried to take a backup of the NAS live database and restore it to our storage and it fails. That is what is bizzare.