SQL Recovery Database problem

Question

1.33/5 (2 votes)

See more:

My Problem: I used the .bak old file restore over the real database without backup (.bak file) of the current database. can anyone help me show how to recovery my database to the current database?

Posted 25-Dec-13 0:51am

Puthiphorn

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-12-25T01:10:00

So: you have restored the wrong backup over the live database and you don't have a current backup, but you want to restore the live data before you restored over the top of it? yes?

You are in what is known as "deep trouble"
AFAIK, there is no "undo" for database restore operations, so you have basically two options:
1) Check if you have Volume Shadowing enabled in Windows - if so, you may be able to restore something from there.
2) Check your whole-PC backups as see if you have anything recent.

The first thing to do is go to your boss and confess - he is going to find out soon enough and you may be able to deflect some of the ire that you are fully due by telling him yourself instead of letting him become aware. He also may know of backups that you don't.

But you are in trouble and unless your company has a good backup regimen / disaster recovery plan, I suspect you may need to start looking for a new job...depending on what info the DB carries.

Christian Graus · Answer 2 · 2013-12-25T01:11:00

Solution 2

If you restored over your old dB, then you erased it, unless you have a newer backup, out complete log files you can run, it is lost.

Posted 25-Dec-13 1:11am

Christian Graus

Comments

Puthiphorn 25-Dec-13 8:37am

Thank you!! but it no ways to get it back in SQL server???

Christian Graus 25-Dec-13 14:34pm

Why are you asking the same thing again ? Here is a link to what I told you is your only chance.
http://www.techrepublic.com/blog/the-enterprise-cloud/restore-your-sql-server-database-using-transaction-logs/

henrydesouza · Answer 3 · 2014-01-04T06:10:00

Hi
Not much can be done at this point of time but thought it might help you a bit.

You should check integrity of your database on regular interval of time so that measures can be taken to minimize the data losses. If you wish to know how to do that check the below link: http://technet.microsoft.com/en-us/library/ms176064.aspx

Maintain regular backup so that if you find any database inconsistency of corruption you will be able to perform repair and restore process easily. Check out how you will be able to do that: http://technet.microsoft.com/en-us/library/ms187510.aspx

If you are not much aware of the recovery process and still needs to perform recovery on MDF or BAK files then I suggest you to check go through these Wikihow Pages to understand better how you will be able to do that by using specialized recovery software.
http://www.wikihow.com/Perform-MS-SQL-Database-Recovery-Through-Software
http://www.wikihow.com/Repair-MS-SQL-Server-Backup-%28.Bak%29-Files-with-the-Help-of-SQL-Backup-Recovery-Software

Go and check if these solutions help you in your cause.
Regards

SQL Recovery Database problem

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0