How is a point in time recovery performed independent of a server down situation? It depends on which backup types are issued. In this example let's assume that full, differential and transaction log backups are issued. Restore the most recent full backup...
What is Use of Backups? Backups is safe guard to Databases because Data may can loss due to many failures such as Media Failures, User errors, Hardware Failures and Natural Disasters etc. With good backups, we can recover database from failures.
What is Backups? Types of backups? (i) “A copy of data that is used to restore and recover the data after a system failure”. There are four types of Backups available (1) Full Backup (2) Differential Backup (3) Transaction Log Backup (4) File /File Group...
What is the default recovery model for system databases? Master - Simple Model - Full MSDB - Simple TempDB - Simple
Explain Full, Bulk-Logged & Simple Recovery Models? Based on the importance of the data, recovery models configured to the Database. a) Full:- Every transaction logged into transaction log file.we can recover the data up to point in time.all production...
What is Recovery Model? Benefits of Recovery Models? “A recovery model is a Database property that control the basic behavior of the backup and restore operations for a DB”. Recovery models are designed to control transaction log maintenance. Explain...
How to set Recovery models using T_SQL? a) To Check current recovery model:- SELECT DATABASEPROPERTYEX('ADVENTUREWORKS', 'RECOVERY') As [Recovery Model] b) To set Simple Recovery model:- ALTER DATABASE ADVENTUREWORKS SET RECOVERY SIMPLE c) To set Bulk-Logged...
CLUSTERING INTERVIEW QUESTIONS. 1 )What is Clustering? Clustering is a technology in which one or more computers work together as a single instance by sharing their resources. Clustering is used mainly for redundancy of the services hosted on it. In other...
1) What is SQL Server? Microsoft SQL Server 2005 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and...
SQL Server – DBCC Commands DBCC (Database consistency checker) are used to check the consistency of the databases. The DBCC commands are most useful for performance and trouble shooting exercises. I have listed down and explained all the DBCC commands...
