What is your company backup policy? If something happend to your db how to restore it?
What type of clustering present used in your enviroment?
Whis is the best replication? Why?
If sql server want to use more ram? How using AWE?
What is the instance name for default?
Types of Migration pre migration steps
Which sp is used in logshipping? Where is it stored?
If read transatcions are applied it will store in the transation log or not?
If you delete any object? Is it possible to restore it how?
If instance is down? How you resolve that issue?
If the problem is repeated several times? What will you do?
How you will know what are the db's involved in logshipping?
What will you do if primary server fails in logshipping?
What mirroring endpoint? How you will find the all endpoints?
Default endpoint for mirroring?
How to find out the db's are involved in mirroring?
What's the safest mode in dbmirroring?
Can we implement the dbmirroring on system db's?
MSBD mandatory for backups? MSBD purpose? If you delete MSDB instance is running or not?
What's the saragate key?
How will you migrate the jobs from one server to another server at the time of migration?
How many productions, UAT & dev servers present in your environment?
What are the other services installed when you install the sql server?
Login can't access? How can you troubleshoot it?
What's the sp for generate error log?
What are the objects in active directory?
What are tools for performance monitor & performane tuning?
We have one db, one user deletes the information? How to find the user?
What's the proxy server?
How to find the performance issue?
One stored procedure runs good? One is very poor? But two queries getting data from same db? How you will identify performance issue?
What is script for taking all backups?
What's the identity property? How you used identify property for replicaton?
In logshipping how to up secondary servers?
Fragmentation? How to identify it?
Command for tail log backup?
For every min n no. of transactions are occuring? So when the backup?
How do you configuring monitor tool?
When updation & insertion is going on backjob has to wait or not
Command for point time restoration?
I have text document with records can I implement clustered index before/later?
In bulk logged why logs are minimally logged?
In what way windows authentication is safe?
What's the capacity planning?
How much time it will take for backup 500gb db?
Which licence is using in your environment?
SQL server is stopped, login got expired? How you will troubleshoot?
In simple recovery model, is it possible to take t-log backup?
closed as not a real question by Mark Storey-Smith, gbn, Martin Smith, ConcernedOfTunbridgeWells, JNK♦ Feb 27 '12 at 13:12
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.