Dear All,
SQL : SQL Express 2005
I having a problem when trying to restore a database. there were around 10 databases, but one is giving the following error and restore fails, will be great if someone helps..
I also tried taking the backup to another site having SQL 2005 Standard edition, the same error comes.
--
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server '.\SQL2K5'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8. (Microsoft SQL Server, Error: 5243)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=5243&LinkId=20476
BUTTONS:
OK
I also installed Service Pack, no luck..HELP!!!
HI,
Refer http://support.microsoft.com/kb/916086 which has workaround and hot fix for the problem.
Hemantgiri S. Goswami
|||Hi,
Thanks for the reply. I went through that already and hence I applied the service pack 1. NO LUCK!!!
Good you pointed the KB link, I am just little confused.It says about "Creating and drop temporary tables...." and what I am doing is Restoring the DB from a backup..Does it mean while restoring temporary tables are created ?
Time is running out, HELP!!
No reply on this from Microsoft Support team!!! where are u guys?
Regards,
