RESTORE is not allowed in an explicit or implicit transaction. Backups that are created by more recent version of [!INCLUDEssNoVersion] cannot be restored in earlier versions of [!INCLUDEssNoVersion].

For more information about transaction log backups, see Transaction Log Backups (SQL Server) and Apply Transaction Log Backups (SQL Server). The full database backup and the last differential backup, ...

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

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

Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure. SQL Server lets you disconnect a database from the main ...

So I've had a case open with Microsoft since October concerning SQL databases that I cannot restore from DPM unless I run a consistency check on them first. Today, it seems they assigned to me yet ...