SQL DBA Mock Interview 9

Поделиться
HTML-код
  • Опубликовано: 18 ноя 2024

Комментарии • 8

  • @sureshrangineni4175
    @sureshrangineni4175 3 дня назад +1

    Awsome and most useful for fresher 😊😊😊😊

  • @sivasankar7013
    @sivasankar7013 4 дня назад +2

    Good video
    What do u mean by dbusers backup
    Databases only right??

    • @SolvedPages
      @SolvedPages  4 дня назад +1

      @@sivasankar7013 whenever we restore database with production database we lose previous users so we have to take backup of database users and have to restore db users after database refresh

    • @sivasankar7013
      @sivasankar7013 4 дня назад +2

      @@SolvedPages we have to execute revlogin same server and execute in same server it self after dropping all databases with ensuring all backups
      Am I right Rajesh???

    • @SolvedPages
      @SolvedPages  4 дня назад +1

      @ Revlogin gives you all the server level logins we don’t need all the logins we just need database users for the specific database

    • @sivasankar7013
      @sivasankar7013 4 дня назад +2

      @@SolvedPages ok we have to go the particular user and make script of that user and restore the scripted file.
      Right Rajesh??

    • @SolvedPages
      @SolvedPages  4 дня назад +1

      @ Yes

  • @smart-vh4xs
    @smart-vh4xs 5 дней назад +1

    In the Log shipping unfortunately one lsn file got deleted then how you can fix the issue steps