There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may be aware that from SQL Server 2005 onwardsyou can use the BACKUP and RESTORE statements to back ...

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be aware that SQL 2000 version uses a counter (rowmodctr) to track row modification and within SQL ...