Sql Server Interview Questions
What are the recovery models for a database? There are 3 recovery models available for a database. Full, Bulk-Logged, and Simple are the three recovery models available. Primarily, the recovery model is chosen keeping in view the amount of data loss one can afford. If one expects to have minimal or no data loss, choosing the Full recovery model is a good choice. Depending on the recovery model of a database, the behavior of the database log file changes. I would recommend you read more material on log backups and log file behavior and so on to understand in depth. How do you trace the traffic hitting a SQL Server? SQL profiler is the SQL Server utility you can use to trace the traffic on the SQL Server instance. Traces can be filtered to narrow down the transactions that are captured and reducing the overhead incurred for the trace. The trace files can be searched, saved off, and even replayed to facilitate troubleshooting. What types of replication are supported in ...