This article helps you troubleshoot common SQL Server backup and restore operations issues. These problems include slow backup or restore performance, version compatibility errors, Always On ...

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...

One of the very mundane, but extremely valuable tasks that any DBA must perform is the backup and restore of databases. In this post, we’ll look at a sample script that can backup databases on a given ...

Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups with ...

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

Use the sp_help_revlogin command to create a login script from the master database of the source server. This script contains the original security identifier (SID) and the original password. You can ...

This article describes how to start running a SQL Server Agent job in SQL Server by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects. A job is a specified series of ...

Disclosure: Our team is always looking for things we think our readers will value. We have received compensation for publishing this article. If you’ve ever had the nightmare of a corrupted SQL backup ...