If you have not created backup or the backup file is not readable, then read this article to know the ways to recover deleted data from MS SQL Server without backup. Ways to Recover Deleted Data from ...

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

The restore features of Windows Server Backup in Windows Server 2008 are appealing, but let down by inflexible backup options and lack of support for Exchange Server and tape drives.

Here, Knowledge Center contributor Brent Ozar outlines seven actions database administrators can perform to build a sound database backup and recovery strategy.

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...