Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. SELECT log_reuse_wait_desc
  2. FROM sys.databases
  3. WHERE name = 'Main DB Name'
  4.  
  5. node log_reuse_wait_desc
  6. ------------------------------------------------------------
  7. primary AVAILABILITY_REPLICA
  8. Secondary-1 LOG_BACKUP
  9. Secondary-2 AVAILABILITY_REPLICA
  10.  
  11. -- On SECONDARY 1
  12. ALTER DATABASE DbName SET HADR OFF;
  13.  
  14. -- On SECONDARY 1
  15. ALTER DATABASE DbName SET HADR AVAILABILITY GROUP = AG_NAME;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement