1) what is your company backup policy?if something happend to your db how to restore it?
2)what type of clustering present used in your enviroment?
3)whis is the best replication?why?
4)if sqlserver want to use more ram?how using AWE?
5)what is the instance name for default?
6)types of Migration pre migration steps
7)which sp is used in logshipping?what it's stored?
8)if read transacions are applied it will store in the transation log or not?
9)if you delete any object?is it possible to restore it how?
10)if instance is down?how you resolve that issue
11)if the problem is repeated several times?what will u do?
12)how you will know what are the db's involved in logshipping?
13)what will you do if primaryserver fails in logshipping?
14)what mirroring endpoint?how you will find the all endpoints?
15)default endpoint for mirroring?
16)how to find out the db's are involved in mirroring?
17)what's the safest mode in dbmirroring?
18)can we implement the dbmirroring on system db's?
19)msdb mandatory for backups?msdb purpose?if you delete msdb instance is running or not?
20)what's the saragate key?
21)how will you migrate the jobs from one server to another server at the time of migration?
22)how many productions,UAT&dev servers present in your environment?
23)what are the other services installed when you install the sqlserver?
24)login can't access?how can u troubleshoot it?
25)what's the sp for generate error log?
26)what are the objects in active directory?
27)what are tools for performance moitor & performane tuning?
28)we have one db,one user deletes the information?how to find the user?
29)what's the proxy server?
30)how to find the performance issue?
31)one stored procedure runs good? one is very poor?but two queries getting data from same db?how you will identify performance issue?
32)what is script for taking all backups?
33)what's the identity property?how you used identify property for replicaton?
34)in logshipping how to up secondary servers?
35)fragmentation?how to identify it?
36)command for tail log backup?
37)for every min n no.of transactions are occuring?so when the backup?
38)how do u configuring monitor tool?
39)when updation & insertion is going on backjob has to wait or not
40)comman for point time restoration?
41)i have text document with records can i implement clusterd index before/later?
42)in bulk logged why logs are minimally logged?
43)in what way windows authentication is safe?
44)setup mirroring?
45)what's the capacity planning?>
46)how much time it will take for backup 500gb db?
47)which licence is using in your environment?
48)upgradation?
49)sql server is stopped, login got expired? how you will troubleshoot?
50)in simple recoverymodel, is it possible to take t-log backup?
kk.subramanyam86@gmail.com (pls send these questions with answers and u r friend)
