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

If it is final full backup and no subsequent differential or log restores, you can run below code and skip the step #5 and step #6 If you want to restore a database to a certain point, restore the ...

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