corrupted mdf? - SQL Server Forums

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

General SQL Server Forums

Data Corruption Issues

corrupted mdf?

Author

Topic

juan08
Starting Member

4 Posts

Posted - 2008-09-18 : 20:02:36

Hi people!

Here my case, but first i would like to let you know that my knowledge of SQL is almost none. i´m gettinglocal help from some that know a lot more but he haven´t been able to solve the problem either.

We format our server to change the OS. We assumed that the database was included in our backup... it was not. we recovered the database with some program and now have the mdf and ldf. The problem is that this mdf was attached to a sql2000 and we are trying to attach it to sql2005.

it is not working. this guy try to attach it to a SQL2000 but it doesnt work either.

I´ve searched the web and found 2 programs that recovered the database. kernel recovery for sql and recovery for sql. both demos of them tell me that the database is ok and even showme a lot of data.

Then I´m assuming that the data base is not damage and the problem could be different. If this last statemente is true how can i figure out what is the problem?

I liked to try to find some help before i invest the 400 USD that any of this program cost.

i´m sure i´ve missed important information that you migth need to help me but of course i have no idea what ifo i should post here, so please ask me and i get any info that you need to help me.

Thank for your interest.

Regards,

Juan

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-09-19 : 04:14:49

How are you trying to attach?

What's the message that you get when you try to attach?

--
Gail Shaw
SQL Server MVP

juan08
Starting Member

4 Posts

Posted - 2008-09-19 : 10:37:28

Here it is...TKS.

===================================

Error de Adjuntar base de datos para Servidor 'SERVER\CORTINEROS'. (Microsoft.SqlServer.Smo)

------------------------------
Para obtener ayuda, haga clic en: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Adjuntar+base+de+datos+Server&LinkId=20476

------------------------------
Ubicación del programa:

en Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files, String owner)
en Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
en Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()

===================================

Excepción al ejecutar una instrucción o un proceso por lotes Transact-SQL. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Ubicación del programa:

en Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
en Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
en Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
en Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
en Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files, String owner)

===================================

No se puede continuar la exploración con NOLOCK debido al movimiento de los datos.
Convirtiendo la base de datos 'generica_dlogic' de la versión 539 a la versión actual 611.
La base de datos 'generica_dlogic' está ejecutando el paso de actualización de la versión 539 a la versión 551. (.Net SqlClient Data Provider)

------------------------------
Para obtener ayuda, haga clic en: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=601&LinkId=20476

------------------------------
Nombre del servidor: SERVER\CORTINEROS
Número de error: 601
Gravedad: 12
Estado: 3
Número de línea: 1

------------------------------
Ubicación del programa:

en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
en System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
en Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-09-19 : 11:34:59

Um, can you translate that please?

It looks like it's complaining about the database version. What was the version and service pack of the server that the DB was from? What's the version and service pack of the server that you're attaching it to? (looks like SQL 2005 RTM - 09.00.1399)

--
Gail Shaw
SQL Server MVP

juan08
Starting Member

4 Posts

Posted - 2008-09-19 : 11:52:50

Here is what I found.

1. You are rigth. today we have SQL2005.09.00.1399
2. The other version was SQL2000. But we were just running the runtime not the whole program. That was one reson to update.
3. No se puede continuar la exploración con NOLOCK debido al movimiento de los datos.
Convirtiendo la base de datos 'generica_dlogic' de la versión 539 a la versión actual 611.
La base de datos 'generica_dlogic' está ejecutando el paso de actualización de la versión 539 a la versión 551. (.Net SqlClient Data Provider)

Translation:

Could not continue scan with NOLOCK due to data movement.
Converting database 'generica_dlogic´ from version539 to actual version 611.
The database ´generica_dlogic´ is executing update step from version 539 to version 551. (.Net SqlClient Data Provider)

I hope it make sense...

Thank you very much for your help Gail.

Juan

juan08
Starting Member

4 Posts

Posted - 2008-09-19 : 12:34:17

Just want to add that this guy that is helping me tryies to attach the database to a sql2000 but it did not work either. i will try to get you the error message appered.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-09-19 : 17:30:32

Can you try attaching the DB using a T-SQL script, rather than the GUI (to the SQL 2005 instance, as I suspect that the upgrade was partially done).

CREATE DATABASE ... FOR ATTACH

You can get the full details in books online.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources