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

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...

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

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

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

Microsoft Corp. last week began letting SQL Server users who have Software Assurance contracts set up fail-over databases at no extra cost, a new policy that some customers said could give Microsoft ...