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...

What are the Agents used for Merge Replication? a) Snapshot Agent b) Merge Agent

What is the best way to update data between SQL Servers? What are the scenarios you will need multiple databases with schema? How will you plan your replication? What are publisher, distributor and subscriber in “Replication”? What is “Push” and “Pull”...

SQL Server Date Functions The following table lists the most important built-in date functions in SQL Server: