![]() 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. By default, every successful backup operation adds an entry in the SQL Server error log and in the system event log.Estimate the size of a full database backup by using the sp_spaceused system stored procedure.For large databases, consider supplementing full database backups with a series of differential database backups. As a database increases in size, full database backups take more time to complete and require more storage space. ![]()
0 Comments
Leave a Reply. |