Summary
Restore of a SQL 2008 Data Base which had transparent data encryption enabled fails.
Symptoms
- You use transparent data encryption on a database in SQL Server 2008 or in Microsoft SQL Server 2008 R2.
- You disable encryption for the database.
- You back up the database immediately after you disable encryption.
- You try to restore the database on another instance of SQL Server by using the backup.
ECX Job Report has the failures below:
Writer [SqlServerWriter] reported error status([VSS_WS_FAILED_AT_POST_RESTORE] [14]) err[0x00000000]
Restore databases: Failed to restore SQL databases (DataBase-Name) on server (Server_Name). Exception (com.syncsort.dp.xsb.commons.XSBException) reports: (Not successful for operation)
Restore databases: Failed to restore SQL databases (DataBase-Name).
The Application event viewer logs on the SQL Server has the error messages below:
Warning 6/22/2017 16:34 VSS 8229 None "A VSS writer has rejected an event with error 0x00000000, The operation completed successfully.
. Changes that the writer made to the writer components while handling the event will not be available to the requester. Check the event log for related events from the application hosting the VSS writer.
Operation:
PostRestore Event
Context:
Execution Context: Writer
Writer Class Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
Writer Name: SqlServerWriter
Writer Instance Name: SQL Server 2008:SQLWriter
Writer Instance ID: {1f89d7a7-3c77-4d13-94eb-d204f35d03fc}
Command Line: ""C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe""
Process ID: 3000"
Error 6/22/2017 16:34 SQLVDI 1 None SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3000. Thread=1316. Client. Instance=. VD=Global\{BE2E4F2B-271B-4270-9329-1FD914011050}_SQLVDIMemoryName_0.
Error 6/22/2017 16:34 SQLWRITER 24583 None "Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Resolution
Microsoft has acknowledged is issue as a Bug and has made a fix for it.
Please follow the Microsoft Article Link below and install the Microsoft provided Hot Fix to the SQL Server.
https://support.microsoft.com/en-us/help/2300689/fix-you-cannot-restore-a-backup-of-a-database-on-another-instance-of-s