Showing posts with label suddenly. Show all posts
Showing posts with label suddenly. Show all posts

Friday, February 24, 2012

Attempted to read or write protected memory

One of the packages we've created a while ago is now, suddenly, giving us a strange error:
There was an error displaying the layout.
Additional Information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (msddsp)
When I click on the help icon, I get:
Event ID: DDSErrorDeserializeDiagram
Source: Microsoft.DataTransformationServices.Design.SR
I should note that I am using custom components, none of which have been changed since the last time this package worked.
When I click ok, all my components have the information icon. No names are displayed (although all are accessible from the properties window) ... When I double click them, I still get the custom UI for my component, and all the properties are there and correct.
Other packages using the same tools work fine.
Any ideas/suggestions?
Thanks,
Steve
I am having a similar problem - did anyone find a solution to this?

Attempted to read or write protected memory

One of the packages we've created a while ago is now, suddenly, giving us a strange error:
There was an error displaying the layout.
Additional Information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (msddsp)
When I click on the help icon, I get:
Event ID: DDSErrorDeserializeDiagram
Source: Microsoft.DataTransformationServices.Design.SR
I should note that I am using custom components, none of which have been changed since the last time this package worked.
When I click ok, all my components have the information icon. No names are displayed (although all are accessible from the properties window) ... When I double click them, I still get the custom UI for my component, and all the properties are there and correct.
Other packages using the same tools work fine.
Any ideas/suggestions?
Thanks,
SteveI am having a similar problem - did anyone find a solution to this?

Thursday, February 16, 2012

attaching DB using single MDF file

Hi there,
I'm trying to attach a DB using a single MDF file. The file was not properly detached as our server had crashed suddenly neither was the a proper backup done..When I try to attach it says
"the file you've specified is not a valid sql server database file" . But another database was restored using a MDF file without any problems ?
Please do get back if anyone may get what the problem likely is ? It'd be of great help. Let me know if my problem was clear or if I've to put it in a different fashion.

Cheers
GaneshOriginally posted by gans_sr
Hi there,
I'm trying to attach a DB using a single MDF file. The file was not properly detached as our server had crashed suddenly neither was the a proper backup done..When I try to attach it says
"the file you've specified is not a valid sql server database file" . But another database was restored using a MDF file without any problems ?
Please do get back if anyone may get what the problem likely is ? It'd be of great help. Let me know if my problem was clear or if I've to put it in a different fashion.

Cheers
Ganesh

what do u mean by
other database was restored using a MDF file without any problems ?
was it the same file which u r trying to restore again??
to me it seems that the database file is corrupted and u will have to look for the most recent backup for the database.|||Harshal,
Its not the same file and its a differnt one . I also reckon it could be corrupt, but do you think it can be repaired by any chance ?
About backup, somehting had happened to hte server it seems , may be some virus and it stopped job schedule on sql server also.
Thanks for any ideas
Ganesh|||Originally posted by gans_sr
Harshal,
Its not the same file and its a differnt one . I also reckon it could be corrupt, but do you think it can be repaired by any chance ?
About backup, somehting had happened to hte server it seems , may be some virus and it stopped job schedule on sql server also.
Thanks for any ideas
Ganesh

In that case u r in a real problem! I haven't heard of repairing a corrupt database file yet.The only solution that I see is to get the latest workable backup from the backup sets and restore them. I hope you have some backups before the job stopped running.
and also once every thing is running, do configure an alert for all the jobs so that their status is mailed to u every time they run.
regards,
Harshal.|||Thanks Harshal .Looks like thats the only option available now.