sql server interview questions
What is TUF File in log shipping ?
TUF file stands for Transaction Undo File inWhat is TUF File in log shipping ?
TUF file stands for Transaction Undo File in SQL Server,
.TUF file is the Transaction Undo File, which is created when performing log shipping to a server in Standby mode.
When the database is in Standby mode the database recovery is done when the log is restored; and this mode also creates a file on destination server with .TUF extension which is the transaction undo file.
This file contains information on all the modifications performed at the time backup is taken.
Explain Backup strategies
What is copy job in log shipping ?
Single user mode
DAC
DB console commands
Pre req for Database mirroring
Performance monitor
Performance tuning
What is fail over clustering how it works ?
What is Quorum ?
What is MSDTC ?
What are the pre req for failover clustering ?
What are your day to day activities ?
How to check SQL server port # ?
Locks
Deadlocks
SQL Architecture
Schema design ?
6/5/2015 5:22 PM - Screen Clipping
DB design
Foreign key
Primary key
How many protocols are there for SQL server
How do you do restore In command line ?
What is extent ?
What are process and threads ?
What is simple recovery ?
How to restrict sql server for local user ?
How to identify temp DB growing ?
What are the ways you can find if the system crashes ?
What will you do if the SQL CPU is very high ?
What you when memory usage is very high ?,
.TUF file is the Transaction Undo File, which is created when performing log shipping to a server in Standby mode.
When the database is in Standby mode the database recovery is done when the log is restored; and this mode also creates a file on destination server with .TUF extension which is the transaction undo file.
This file contains information on all the modifications performed at the time backup is taken.
Explain Backup strategies
What is copy job in log shipping ?
Single user mode
DAC
DB console commands
Pre req for Database mirroring
Performance monitor
Performance tuning
What is fail over clustering how it works ?
What is Quorum ?
What is MSDTC ?
What are the pre req for failover clustering ?
What are your day to day activities ?
How to check SQL server port # ?
Locks
Deadlocks
SQL Architecture
Schema design ?
6/5/2015 5:22 PM - Screen Clipping
DB design
Foreign key
Primary key
How many protocols are there for SQL server
How do you do restore In command line ?
What is extent ?
What are process and threads ?
What is simple recovery ?
How to restrict sql server for local user ?
How to identify temp DB growing ?
What are the ways you can find if the system crashes ?
What will you do if the SQL CPU is very high ?
What you when memory usage is very high ?