When you try to restore a database there are some very tricky stuff you need to know.

A list of widely used SQL settings Explained ANSI NULLS QUOTED_IDENTIFIER ARITHMABORT ANSI_DEFAULTS ANSI_WARNINGS DATEFIRST DATEFORMAT NOCOUNT NOEXEC IDENTITY_INSERT IMPLICITY_TRANSACTIONS

Continue readingT-SQL Settings Explained