Errors in attaching mdf after ldf corruption or deletion
Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted. This errors happens when corrupt database log are attempted to attach to new server. Solution of this error is little long and it involves restart of the server. I recommend following all the steps below in order without skipping any of them. Fix/Solution/Workaround: SQL Server logs are corrupted and they need to be rebuilt to make the database operational. Follow all the steps in order. Replace the yourdatabasename name with real name of your database. 1. Create a new database with same name which you are trying to recover or restore. (In our error message it is yourdatabasename ). Make sure the name of the MDF file (primary data file) and LDF files (Log files) same as previous database data and log file. 2. Stop SQL Server. Move original MDF file from older server (or location) to new server (or location) by replacing just created MDF file. Del...
Commenti