Explain the concepts of faster differential backups.
Differential backups are a faster mechanism of taking backups. The back up taken is only of the recently made changes in the data from the last differential backup taken. They support frequent backups which decrease the risk of data loss. The information about the differential database for each file is maintained in a catalog in the primary filegroup.
Explain the concepts of Parallel Database consistency check (DBCC)
DBCC performs a check on the tables and views for any corruptions. The command DBCC CHECKTABLE checks for integrity of the data, index, text, ntext, and image pages for the specified table or indexed view. DBCC checks if the pointers are consistent, data on each page is rational, the offsets of pages are proper and indexes are in their proper sort order. The DBCC CHECKTABLE returns a result set.
Example: To checks the data page integrity of the authors table.
DBCC CHECKTABLE (‘sample’)
GO
No comments:
Post a Comment