SQL database is crashed
Closed
morrisonn
Posts
2
Registration date
Monday April 4, 2016
Status
Member
Last seen
April 17, 2016
-
Apr 10, 2016 at 08:54 AM
RuneLassen Posts 2 Registration date Tuesday April 12, 2016 Status Member Last seen April 17, 2016 - Apr 17, 2016 at 12:33 PM
RuneLassen Posts 2 Registration date Tuesday April 12, 2016 Status Member Last seen April 17, 2016 - Apr 17, 2016 at 12:33 PM
Hello,
Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file.
Is it possible to bring the DB (.MDF) in the old backup to Live standard using the new/latest Log file? If so, how? Any help is truly appreciated.
Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file.
Is it possible to bring the DB (.MDF) in the old backup to Live standard using the new/latest Log file? If so, how? Any help is truly appreciated.
Related:
- SQL database is crashed
- Access database download - Download - Databases
- Oracle sql datediff - Guide
- Borland database engine download - Download - Databases
- Sql dbx - Download - IDE
- Client server database architecture - Guide
2 responses
RuneLassen
Posts
2
Registration date
Tuesday April 12, 2016
Status
Member
Last seen
April 17, 2016
1
Apr 17, 2016 at 10:25 AM
Apr 17, 2016 at 10:25 AM
Follow the steps mentioned below:
- Take a tail log backup of your database after your full backup
- Restore your Full backup available with you using WITH NORECOVERY option.
- Restore Differential backups ( if you have in order) WITH NORECOVERY option
- Restore Transactional log backup in order WITH NORECOVERY and the last tail backup taken using WITH RECOVERY option..
RuneLassen
Posts
2
Registration date
Tuesday April 12, 2016
Status
Member
Last seen
April 17, 2016
1
Apr 17, 2016 at 12:33 PM
Apr 17, 2016 at 12:33 PM
Ok, If your database is not functional now, then you can't take tail log backup.
In that case, try the steps given below:
Test whether this works or not.
In that case, try the steps given below:
- Detach your database
- Copy your LDF File to a new location
- Attach MDF File without providing LDF file..
Test whether this works or not.
Apr 17, 2016 at 11:33 AM