Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it ...

SQL Server keeps a buffer of all of the changes to data for performance reasons. It writes items to the transaction log immediately, but does not write changes to the data file immediately.

Log files can be damaged due to malware or virus attacks on the system hosting the SQL server; If the SQL Server account permissions and configuration are modified incorrectly, it can impact the log ...

Each page server is responsible for a subset of the pages in the database. Each page server also has a replica that is kept for redundancy and availability. The job of a page server is to serve ...

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 ...

Learn how to view the data and log files in a backup set in SQL Server by using SQL Server Management Studio or Transact-SQL. In [!INCLUDEsql2008-md] and later versions, obtaining information about a ...

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file. Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.