How to restore a SQL Server 2008 database

Tags:
SQL Server 2008
Dead database. Looked at backups but the last backup made three weeks ago, then the operation was executed with an error and I didn't notice: - (mdf and ldf aren't copied by the conductor. errors in the file. using Active File Recovery had copied the mdf. then I passed Windows Check Disk. Windows Check Disk killed ldf completely. Windows Check Disk said that in mdf everything is fixed but the file isn't copied. and so it is broken mdf and a three-week backup similar structure. Is it possible now to restore the database somehow? Thanks for advance!
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try just in
case to run SQL Server Management Studio

To connect
to the server under the administrator account or the Database owner.

Click the
right mouse button on “Database” and select in the menu “Restore
– >

On the
“General” to perform the following steps:

In the  field “To database” enter a name
for the restored database (if you specify the name of an existing database,
then this is equivalent to the fact that first completely remove the existing
database and then restore from a backup of the new database, i.e., all data of
the existing database will be lost!);

To install
switch “From device” and specify the path to the backup file by
clicking “…”;

To
establish a tick of “Restore” in the necessary line. On the page
“Options” set a tick 
“Overwrite the existing database (whith replase)” and check
the paths in the list Restire the database files as” (the path must
specify an existing folder on the SQL server to which you have given write
permissions – paths by default usually must end with the DATA folder, but MSSQL
isn’t simple).

Click
“OK”.  

But in my
opinion, without Recovery Toolbox for SQL Server you can not do. With its help,
you can try to rebuild your base. I hope it will help you.

https://sql.recoverytoolbox.com/

Good luck!

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: