on 06-07-2015 1:55 PM
I have a SQL 2005 .bak file that looks to be corrupt. It won't restore using standard gui restore method. The file size looks correct (9.8 GB) but it wont restore. The prior day works but unfortunately this is the one day my server harddrive has completely died. Any way to repair or restore this .BAK and see the data? Inside this database is a single table that may allow me to get my missing day added to my yesterday working database.
First of all make use step by step instruction for restoring sql database by SQL Server Management Studio, in case even this one guide can't be effective, check out https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What's the matter? Do you want to restore your SQL database from the backup file or you want to repair SQL database? If you want to repair corrupt SQL database file, you should try Microsoft SQL Server Management Studio. This can help you remove your SQL database tagged as suspect. Read the blog post linked below for more information:
Repair SQL Database using SQL Server Management Studio | N.Sem's Blog
But if you want to restore your SQL database from corrupt backup file, you can try a BKF recovery software that supports recovery of SQL database from corrupt BKF files.
Thanks and best regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Basically there are many reasons which are responsible for SQL database corruption like hardware failure, improper power supply, virus attack and more but such issues in SQL Server database can be more easily with the help of SQL Database Recovery Software to Rebuild Corrupt or Inaccessible MDF Database Files designed for this purposes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Easiest way to recover for SQL database, you can use SQL Database Recovery software which can easily repairs corrupt MDF file of SQL Server database. And that software also recover tables, triggers, indexes, keys, constraints, rules, and defaults.It also supported with all SQL Server Versions MS SQL Server 2000, 2005, 2008, 2008 r2 and 2012.Go through: SQL Database Recovery tool to Repair Corrupt SQL Server .MDF Files
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try advance SQL Backup Recovery Tool to repair all SQL backup items including tables, views, triggers, store procedure, function, keys etc. The software allows you to recover SQL Backup database of any size and export into SQL Server or SQL Server Compatible Script.
For More details: - http://www.sqlrepairtool.org/sql-server-backup-restore-software.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Salmaan
I think its very difficult to repair or restore the database from corrupted bak file. You have to find the some of the third party tools, I am not sure those tool will be helpful.
1. You have to search good backup set.
2. Try to recover the DB from the fault server.
3. Could you share the error message or snapshot at the time of restoration?
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
what is the exact errormessage ?
Can you please create a script of the restore command (in the gui there is a scripting button) and send it to us.
Best regards
Clas Hortien
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.