Friday, February 24, 2012

Database Recovery

i have a database which restored with a null database. how can i recover my previous data? i have no backup.

It is not clear what you mean by 'null database'.

IF you have restored a database from a 'empty' database (either by replacing the files or using a backup), and IF you do not have another backup with data -you are out of luck and need to quickly type up and send out your rsum.

There is no way to recover data that doesn't exist (except for re-entering it by hand), and without backups, in your situation, it appears that the data no longer exist.

|||

Arnie Rowland wrote:

It is not clear what you mean by 'null database'.

IF you have restored a database from a 'empty' database (either by replacing the files or using a backup), and IF you do not have another backup with data -you are out of luck and need to quickly type up and send out your rsum.

There is no way to recover data that doesn't exist (except for re-entering it by hand), and without backups, in your situation, it appears that the data no longer exist.

i restore it with a wrong backup file. really there is no way?|||

The restore will have overwritten the data files so you won't be able to get anything from the current database.

If you have a disk backup you might be able to attach the .mdf otherwise if you don't have a backup then I'm afraid you've lost it.

|||Unfortunately, DBA skillsets STILL do not include magic! (Although at times it may seek like we do practice the 'black arts' ... Mostly, just sticking pins in PM dolls ... )

No comments:

Post a Comment