ü
Backup the exisitng dataabse
|
ü
Take the security backup
|
ü Remove the databases from availability group : AlwaysOn High
Availability --> Availability Groups
è
Group Name Ex:AG_Test
-->Availability Databases --> DatabaseName
--> Remove Database
Name from Availability Group
|
ü
Restore the databases
|
ü
Execute the security
permissions ( which you have taken before restore) on newly restored
database.
|
ü
Remove the availability
databases on secondary
|
ü
Add the databases to the
Availability group
|
Labels
- Differences (38)
- MongoDB (13)
- MySQL (10)
- Oracle (6)
- ORACLE DBA (1)
- Performance Tuning (13)
- PTuning (3)
- Scenarios (4)
- Scripts (35)
- SQLDBA (99)
- SQLDeveloper (66)
- SSIS (5)
- SSRS (8)
- Troubleshooting (37)
Tuesday, 14 March 2017
How to restore database in AG
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment