Unable to Restore the Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Unable to Restore the Database

Author

Topic

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-04-11 : 05:29:11

Hi,
I am getting the following error when i try to restore the database on SQL Server 2008 instance.

Restore failed for server 'servername\instancename'
Additional Information
System.Data.SqlClient.SqlError: The "dbname_log" failed to initialized correctly. Examine the log for more details.(Microsoft.SqlServer.Smo)

When i see the sql server log, it was showing the following error, given below.
The file "dbname_log" failed to initialize correctly. Examine the error logs for more details.

I wants to explain few more points regarding this
I have done the following things on the Database server (from where i have taken the backup)
CREATE MASTER KEY
CREATE CERTIFICATE
CREATE DATABASE ENCRYPTION KEY

and then enabled the TDE encryption on the Database
and before taking the backup i disabled the TDE on the database and then taken the Backup.

I know this problem is something related to TDE but i have created the same MASTER KEY and CERTIFICATEs on the new instance where i want to restore the Database.

I am struck due to this. I have the same Master key and certificate and i have created the both on the new server, but still getting the same error

any help regarding this will be highly appreciated.

Regards.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-11 : 08:21:14

https://connect.microsoft.com/SQLServer/feedback/details/351548/rc0-engine-disabling-tde-from-a-database-does-not-allow-it-to-be-attached-restored-later

--------------------------
http://connectsql.blogspot.com/

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-04-11 : 09:01:24

i have the keys , which i have create, but it is still giving the error.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-11 : 10:29:42

quote:
The file "dbname_log" failed to initialize correctly. Examine the error logs for more details.

And what do the error logs say?

--
Gail Shaw
SQL Server MVP

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-04-12 : 01:07:42

Error log says this

The file "dbname_log" failed to initialize correctly

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-12 : 01:49:48

Is that the only message in the error log? Should be more.

--
Gail Shaw
SQL Server MVP

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-04-13 : 05:00:57

The error log does not contain any other information

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-04-13 : 11:07:46

do you have the same folder structure for mdf and ldf in destination server that existed in source server? h:\dbname.mdf l:\dbname_log.ldf?

If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources