Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. --On secondary database with error "NOT SYNCHRONIZED / RECOVERY PENDING", run:
  2. ALTER DATABASE <database_name> SET HADR OFF;
  3. ALTER DATABASE <database_name> SET HADR AVAILABILITY GROUP = <ag_name>;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement