![]() ![]() You can still restore backups created with passwords. ![]() For information about how to set TRUSTWORTHY to ON, see ALTER DATABASE SET Options (Transact-SQL).īeginning with SQL Server 2012 (11.x), the PASSWORD and MEDIAPASSWORD options are no longer available for creating backups. TRUSTWORTHY is set to OFF on a database backup. For more information, see Trace Flags (Transact-SQL). In such cases, you can suppress these backup log entries by using trace flag 3226 if none of your scripts depend on those entries. ![]() If you back up frequently, success messages will accumulate quickly, resulting in huge error logs, making finding other messages difficult.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |