DBA Questions RRS feed

  • Question

  • Hello all,

    I faced following DBA questions which I could not answer. Please help.

    1. Due to which db setting the log file size does not reduce on running shrinkfile command just after making the log file size          100 gb or so due to heavy transaction ?

    2. What is the reason of persistent db restoring activity even after it is shown that the restore is 100% ?

    3. What to do if master db crashes ?

    4. Can we restore msdb ?

    5. How to check the versions of all the db servers in a network from ssms at once ?

    6. How to transfer users and jobs from one server to another ?

    7. What is file sharing in alwayson ?

    Saturday, October 26, 2019 11:26 AM