I am currently testing SQL Server 2000 Evaluation version.
I created a diagram with the diagraming tool, but in the process I mistakenly deleted the system table 'dtproperties'. I have a backup of the database, but the last time I restored it, I lost my diagram (and had to do it again)
What I've done to try to get it back:
I have another database with the old table schema, and I tried to enter all the values it that old database's dtproperties into the recent db's dtproperties, but that didnt' work especially since I didn't know how to copy the lvalue column.
How can I restore my diagram?I believe no chance to retrieve the diagram as you're using EEE.
Showing posts with label mistakenly. Show all posts
Showing posts with label mistakenly. Show all posts
Monday, March 19, 2012
Mistakenly dropped database in SQL Server! Data recovery?
Could anyone please help with any ideas?
A database was mistakenly dropped in SQL Server. There were no backup files
. Nothing else has been written to the hard drive so the data should still
be on the hard drive (not overwritten). Can anyone help or offer any ideas
as to how I might be able t
o recover this? Is there data recovery software that will look at the hardd
rive to find and restore this data (similar to a recycle bin restore?) Any
assistance would be greatly appreciated as soon as possible. I would be ve
ry grateful for any ideas/s
uggestions.search on google for undelete or unerase softwares, there are plenty of them
available.
but they will work only till nothing else overrites on the disk.
And its always good to have backups of important databases.
regards,
harshal.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:404D6405-6AD1-48CB-BC01-5CEC9A87DD1A@.microsoft.com...
> Could anyone please help with any ideas?
> A database was mistakenly dropped in SQL Server. There were no backup
files. Nothing else has been written to the hard drive so the data should
still be on the hard drive (not overwritten). Can anyone help or offer any
ideas as to how I might be able to recover this? Is there data recovery
software that will look at the harddrive to find and restore this data
(similar to a recycle bin restore?) Any assistance would be greatly
appreciated as soon as possible. I would be very grateful for any
ideas/suggestions.
A database was mistakenly dropped in SQL Server. There were no backup files
. Nothing else has been written to the hard drive so the data should still
be on the hard drive (not overwritten). Can anyone help or offer any ideas
as to how I might be able t
o recover this? Is there data recovery software that will look at the hardd
rive to find and restore this data (similar to a recycle bin restore?) Any
assistance would be greatly appreciated as soon as possible. I would be ve
ry grateful for any ideas/s
uggestions.search on google for undelete or unerase softwares, there are plenty of them
available.
but they will work only till nothing else overrites on the disk.
And its always good to have backups of important databases.
regards,
harshal.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:404D6405-6AD1-48CB-BC01-5CEC9A87DD1A@.microsoft.com...
> Could anyone please help with any ideas?
> A database was mistakenly dropped in SQL Server. There were no backup
files. Nothing else has been written to the hard drive so the data should
still be on the hard drive (not overwritten). Can anyone help or offer any
ideas as to how I might be able to recover this? Is there data recovery
software that will look at the harddrive to find and restore this data
(similar to a recycle bin restore?) Any assistance would be greatly
appreciated as soon as possible. I would be very grateful for any
ideas/suggestions.
Mistakenly dropped database in SQL Server! Data recovery?
Could anyone please help with any ideas?
A database was mistakenly dropped in SQL Server. There were no backup files. Nothing else has been written to the hard drive so the data should still be on the hard drive (not overwritten). Can anyone help or offer any ideas as to how I might be able to recover this? Is there data recovery software that will look at the harddrive to find and restore this data (similar to a recycle bin restore?) Any assistance would be greatly appreciated as soon as possible. I would be very grateful for any ideas/suggestions.search on google for undelete or unerase softwares, there are plenty of them
available.
but they will work only till nothing else overrites on the disk.
And its always good to have backups of important databases.
regards,
harshal.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:404D6405-6AD1-48CB-BC01-5CEC9A87DD1A@.microsoft.com...
> Could anyone please help with any ideas?
> A database was mistakenly dropped in SQL Server. There were no backup
files. Nothing else has been written to the hard drive so the data should
still be on the hard drive (not overwritten). Can anyone help or offer any
ideas as to how I might be able to recover this? Is there data recovery
software that will look at the harddrive to find and restore this data
(similar to a recycle bin restore?) Any assistance would be greatly
appreciated as soon as possible. I would be very grateful for any
ideas/suggestions.
A database was mistakenly dropped in SQL Server. There were no backup files. Nothing else has been written to the hard drive so the data should still be on the hard drive (not overwritten). Can anyone help or offer any ideas as to how I might be able to recover this? Is there data recovery software that will look at the harddrive to find and restore this data (similar to a recycle bin restore?) Any assistance would be greatly appreciated as soon as possible. I would be very grateful for any ideas/suggestions.search on google for undelete or unerase softwares, there are plenty of them
available.
but they will work only till nothing else overrites on the disk.
And its always good to have backups of important databases.
regards,
harshal.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:404D6405-6AD1-48CB-BC01-5CEC9A87DD1A@.microsoft.com...
> Could anyone please help with any ideas?
> A database was mistakenly dropped in SQL Server. There were no backup
files. Nothing else has been written to the hard drive so the data should
still be on the hard drive (not overwritten). Can anyone help or offer any
ideas as to how I might be able to recover this? Is there data recovery
software that will look at the harddrive to find and restore this data
(similar to a recycle bin restore?) Any assistance would be greatly
appreciated as soon as possible. I would be very grateful for any
ideas/suggestions.
Subscribe to:
Posts (Atom)