I have made the biggest mistake and deleted the transaction log file. Is there a way to fix this issue? I have the backup file, is there a way to restore it or reset everything again?

enter image description here

  • Your connection string is wrong or server is not running – sepupic Dec 18 '18 at 6:59

Backup contains the log file as well.

Just restore the database using tsql

Restore database db_name from disk = ' path to backup file.bak' with replace, stats=10

Based on your screenshot, it seems a connection issue .. you are not able to connect to SQL server with ssms.

Also, see this blog by Aaron https://sqlblog.org/2011/01/14/troubleshooting-error-18456

| improve this answer | |
  • thanks for the answer! I'm not sure how to use that command in tsql; In the end, I reinstall the SQL Server and restore the backup! – Jee Mok Dec 18 '18 at 7:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.