Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines. The Azure ...

I've been scratching my head about this for quite some time and can't quite figure it out. I have a share on Server1 (Windows 2008 R2) and Server2 (Windows 2012 R2) that I use to store SQL backups ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

I was testing out some new SQL Server 2008 features recently: Transparent Data Encryption (TDE) and Backup Compression. Both are new features in SQL Server 2008. TDE will allow you to encrypt an ...

Users who have to support Microsoft SQL database servers, but prefer to run Linux as a data back-up/storage platform, may be interested in a new software plug-in from Arkeia. The Arkeia Network Backup ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

I have a SQL server that is freezing IO on all DBs 6 times per day at about 2am, 6am, 10am, 2pm, 6pm, and 10pm. These only freeze IO for approximately 2 seconds each time, but it is long enough that ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...