Database Recovery

6 Key Best Practices to Keep in Mind for SQL Server Profiler

In this article we learn about SQL Profiler, and what are the best practices to be undertaken when using it for tracing. If you have been using SQL Server Trace feature for long, you might also be used to making use of the SQL Profiler feature. This feature is the GUI for the SQL Trace, using the Profiler in SQL, it becomes easier to create, manage, and analyze the results of SQL Trace. However, there are certain key practices that you need to keep in mind when making use of the SQL...

Read more »

Salient Aspects of Bulk Logged Recovery Model in SQL Server

In this article we explain you all about the Bulk Logged Recovery Model Available in SQL Server. Read to know how, when and why to use it. The processes of backing up data and restoring backed up data in SQL Server happens in the Recovery models provided by the application. Recovery models in SQL Server are provided by default, and have been given for the very important purpose of controlling the maintenance of the transaction log. It is the recovery model that manages how the transactions...

Read more »

A Quick Overview of Differential Backups in SQL Server

Learn all about differential backups; their working, and when to put them to use. SQL Server databases are the ones which are not used for storing any ordinary data. All the medium, small, as well as the enterprise level organizations that make use of this software, also give equal importance and emphasis to the backups of these databases. Backing up SQL Server databases is one of the most important things you need to do when using them. And when it comes to backing up SQL Server data,...

Read more »