News

If the transaction log file is corrupted or missing, you need to restore it. In this article, we’ll discuss how to rebuild SQL database when log file is corrupt. Causes for Corrupt SQL Transactional ...
After completing these steps, your database transaction log file should be at a normal size, and if you implement the process discussed in my “Avoiding ginormous transaction logs with SharePoint ...
Every SQL Server database has at least two files; a data file and a transaction log file. The data file stores user and system data while the transaction log file stores all transactions and ...
There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated data (.mdf) file is at the size it should be ...
If you’ve the database backup available and know the time of data deletion, you can use the transaction log with Log Sequence Number (LSN) to recover the deleted data from SQL Server. However if you ...