1. Unable to start SQL Server, what is the reason, how to find issue? A: Check Physical Error Log path : Open Configuration Manager > RC properties of Instance >Advanced check Startup Parameter 2. Log file is corrupted (there is no backups, how u will...

Log file is corrupted (there is no backups, how u will get database? A: SELECT name, state, state_desc FROM sys.databases WHERE name='ABCD' Output for state_desc was RECOVERY_PENDING. I instructed him to set database to the emergency mode. ALTER DATABASE...

Resource Governor 1. What is Resource governor? A: Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption. We can limit the amount of CPU and memory consumption by limiting /governing /throttling on the SQL...

SQL DBA-INTERVIEW QUESTIONS INTERVIEW QUESTIONS --------------------------------------------------------------------------------- 1. What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We...

· What is a “Database Transactions “? · What is ACID? · What is “Begin Trans”, “Commit Tran”, “Rollback Tran” and “Save Tran”? · What are “Checkpoint’s” in SQL Server? · What are “Implicit Transactions”? · Is it good to use “Implicit Transactions”? ·...