Hi guys,
I've never worked with a clustered environment until recently so excuse the possible lack of knowledge on this one...
Basically we have a 4 DB application and each month we do a data publication that happens offline and then means that 2 of the DBs have to be detached and the new updated DBs are attached during a maintenance window - While this worked in non clustered environments as the process was pretty simple...
- Detach DBs from LIVE Server
- Attach new DBs
- DONE.
.. We're not LIVE yet with the new clustered system yet but from what I can tell by trying to replicate the process is that it seems rather long and drawn out to get new DBs onto the server.. from what I have been doing the process to do the above on new clustered system seems as follows...
- Remove databases from Availability group on Secondary Server
- Delete databases from Secondary server
- Remove databases from Availability group on Primary Server
- Detach DBs from Primary Server
- Attached DBs to primary Server
- Change recovery mode to FULL for both DBs
- Perform a full backup of each new DB
- Copy the backup into the share so the secondary server can see
- Add DBs back into the Availability group on the primary server
- Perform FULL synchronisation between servers.
- DONE
Am I missing a much simpler way of doing this - or is that just how it needs to happen?
any help/guidance/direction is greatly appreciated...
Cheers,
Dan
I've never worked with a clustered environment until recently so excuse the possible lack of knowledge on this one...
Basically we have a 4 DB application and each month we do a data publication that happens offline and then means that 2 of the DBs have to be detached and the new updated DBs are attached during a maintenance window - While this worked in non clustered environments as the process was pretty simple...
- Detach DBs from LIVE Server
- Attach new DBs
- DONE.
.. We're not LIVE yet with the new clustered system yet but from what I can tell by trying to replicate the process is that it seems rather long and drawn out to get new DBs onto the server.. from what I have been doing the process to do the above on new clustered system seems as follows...
- Remove databases from Availability group on Secondary Server
- Delete databases from Secondary server
- Remove databases from Availability group on Primary Server
- Detach DBs from Primary Server
- Attached DBs to primary Server
- Change recovery mode to FULL for both DBs
- Perform a full backup of each new DB
- Copy the backup into the share so the secondary server can see
- Add DBs back into the Availability group on the primary server
- Perform FULL synchronisation between servers.
- DONE
Am I missing a much simpler way of doing this - or is that just how it needs to happen?
any help/guidance/direction is greatly appreciated...
Cheers,
Dan
