Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

As you can see, traditional database backup and Zetta's DataProtect service featuring ZettaMirror are really 2 totally different ways to do SQL server backup and recovery. If you're ready to try the ...

I was wondering about backups on SQL Server 05. <BR><BR>You’ll have to bear with me on this as I’m suffering from the “*$&#*# it Jim, I’m a developer not a database server administrator!” but, I can’t ...

Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...

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