SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem while attached the database


Problem while attached the database

Author
Message
Satisha
Satisha
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
Hi,
My Client is facing some data losss and also his machine was corrupted. so they copied the database file (mdf) directly from SQL server installation path (c:/program files/SQL Server/MSSQL/data/) from his machine and sent, i am trying to attach that database to my SQL server datbase for analysis i am getting one Error message box with the following message while trying to attach.
Error 3624
location: recovery.c:2412
Expression: seenCkptdEnd
SPID: 51
Process ID: 1820
Anybody has a solution for this
With regards
Satisha

Salil Sunil Sule-353027
Salil Sunil Sule-353027
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 70

HI,

Check out if this link is useful for u:-

http://support.microsoft.com/kb/825197/

Also use dbcc checkdb and dbcc checktable for checking the corruption.

bye

Salil


ntdoc
ntdoc
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 18

Well this was posted in the SQL 2005 forum so if that KB does apply then this post is in the wrong forum as that KB is for SQL 2000 and ultimately resolves the issue by installing a Service Pack for SQL.

I agree the checks are good though.


Neil Coombes
Neil Coombes
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 21

I have had this sort of scenario before and found that because I could not attach the database I could not run commands such as dbcc checkdb (if you have access to the original machine then you should try running it on that to get the data in a better state before taking a copy of the mdf (and ldf if possible).

Anyway assuming that you just have an mdf file which you can't attach to your db engine the only useful tool I have found is Recovery for SQL. Basically you point it at an mdf file and it extracts everything it can find to a load of sql scripts which you can then use to rebuild your data on a blank database. The only problem I have found with this tool is that at the rebuild stage it wants to run the schema file first which means that the data can't be added back in as it tends to fail the constraints because the tool has no chance of knowing what order it should being adding the data in to satisfy the constraints on the tables.

If you find you have this same problem then you may need to create a blank database run the schema script and then remove any constraints it creates. and then recreate the constraints once the data is in place.

Anyway if your interested the tool is availble from the website below for $499 and it has saved a couple of my clients data who were in the same scenario you described.

http://www.officerecovery.com/mssql/index.htm

If anyone knows of other tools like this that they have used successfully then I would like to know about them too (especially if they are free) as you can never have too many recovery tools.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search