File and Filegroup Backups

File and Filegroup Backups.

File or Filegroup backups support backing up and restoring individual files or filegroups. This is usually used in very large database where there may not be a lot of time to backup the complete database. File and file groups can be restored from a full database backup set. This allows a quicker recovery because only the file and the file groups that are damaged are restored first
What is cursor in SQL Server?
A Cursor is a database object that represents a result set and is used to manipulate data row by row........
Define the steps to use Transact-SQL Cursor
Declare the cursor, Open the cursor, Fetch record row by row, Close cursor, Deallocate cursor........
Explain the cursor types
DYNAMIC: It reflects changes happened on the table while scrolling through the row........
Post your comment