SQL Server restore database which is part if alwayson

1zmg4dgp 于 2023-06-28 发布在其他

关注(0)|答案(2)|浏览(139)

I have DR activity where I will have to install sql server 2016 and resotore all databases including system databases. From the backup of production. Prod server is configured with always on.

So if I restore master Database before user database I believe I will not able to restore user database which might through an error like "cannot restore database as it is participating in alwayson".

Can anyone provide solutions for it?

sql-server

来源：https://stackoverflow.com/questions/56114703/restore-database-which-is-part-if-alwayson

2条答案

按热度按时间

2skhul331#

If you need to restore an availability group database, you need to first evict that database from availability group and then restore that database and finally you can re-add it to the always on availability group. So, there are three steps involved in restoring an AOAG database.

1. Remove identified database from Availability Group.
2. Restore that database.
3. Add database to Availability Group post restore operation.

赞(0）回复(0）举报 2023-06-28

k5ifujac2#

It only shows following error when we do not enable always on future in configuration manager. Once we enabled database gets restore as usual.

cannot restore database as it is participating in alwayson".

赞(0）回复(0）举报 2023-06-28

我来回答

SQL Server restore database which is part if alwayson

2条答案

相关问题

热门标签

最新问答