Jump to content

Moving existing DB to new installed Server and OS


Da_Real_Keith
 Share

Recommended Posts

Hi,

 

we have two installations on server 2016. One is active and uses a shared sql-2012 installation, the second server is passive and read only. We are on version 9073 and want to install both installations new and with actual versions with an own sql express server.

 

My question now is... is it supportet to install both server (active and passive-read-only) with sql express? And how can we import-export the database from the native sql to the sql-epress installation?

 

We want to install two new server 2019 and a fresh, actual version from passwordstate.

 

Thanks for help!

 

Best regards,

 

tha REAL Keith

Link to comment
Share on other sites

  • Da_Real_Keith changed the title to Moving existing DB to new installed Server and OS

Hello,

 

The bare minimum requirement for SQL High Availability is your primary SQL Server needs to be SQL Server Standard and above, and the HA SQL Server can be using SQL Express. This is an active/passive configuration.

We have various instructions on the following page for SQL Server High Availability, and also for doing moves of our software https://www.clickstudios.com.au/documentation/

Regards

Click Studios

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...