427 - Migrating Redstor Pro SQL databases from SQL Express to a separate SQL Server

Follow the instructions below to migrate the Redstor Pro SQL databases from SQL Express to a separate SQL Server:

Note: This procedure can be performed for both AccountServers and Slave AccountServers.

1. Stop the AccountServer service.
2. Using SQL Management Studio, back up the Account (Storage Platform) and Report (StoragePlatformReports) databases in full to local disk.
3. Using SQL Management Studio, connect to the separate SQL Server. Restore the databases backed up from SQL Express. The databases can be renamed at this stage if desired.

   Notes:

   • It is possible to restore e.g. a SQL 2012 to a SQL 2014 Server, but not to restore SQL 2012 to SQL 2014 without setting the compatibility level of the database.
   • If you are changing the database name, make sure that the logical name of the database matches the name of the files or replication will fail. See FAQ Article 431 for more information on how to change database names.

   Configure an appropriate user for the AccountServer to connect as. Ensure that this user is granted db_owner permission to the Account and Report databases.

4. On the AccountServer machine, navigate to the installation folder. Open ConnectionStrings.config and edit this as follows:
   
   1. Change the DataService and BackupServer entries for the Account database. Set the Data Source to point to the new database server instance, the Initial Catalog to the Account database name, the Password to the SQL login password, and User ID to the SQL user.
      The details used in this example are as follows:

      Data Source=SQLTESTDB\MSSQL
Initial Catalog=StoragePlatform
Password=Password123
User ID=sp_user

      <add name="DataServices" connectionString="metadata=res://*/DataAccess.Entities.DataModel.csdl|res://*/DataAccess.Entities.DataModel.ssdl|res://*/DataAccess.Entities.DataModel.msl;provider=System.Data.SqlClient;provider connection string="Password=Password123;Persist Security Info=True;User ID=sp_user;Initial Catalog=StoragePlatform;Data Source=SQLTESTDB\MSSQL;MultipleActiveResultSets=True\"
          providerName="System.Data.EntityClient" />
      <add name="BackupServer" connectionString=";Password=Password123;Persist Security Info=True;User ID=sp_user;Initial Catalog=StoragePlatform;Data Source=SQLTESTDB\MSSQL;MultipleActiveResultSets=True" />

   2. Change the ReportService and ReportServer entries for the Account database. Set the Data Source to point to the new database server instance, the Initial Catalog to the report database name, the Password to the SQL login password, and User ID to the SQL user.
      The details used in this example are as follows:

      Data Source=SQLTESTDB\MSSQL
Initial Catalog=StoragePlatformReports
Password=Password123
User ID=sp_user

      <add name="ReportService" connectionString="metadata=res://*/DataAccess.Entities.ReportModel.csdl|res://*/DataAccess.Entities.ReportModel.ssdl|res://*/DataAccess.Entities.ReportModel.msl;provider=System.Data.SqlClient;provider connection string=\"Password=Password123;Persist Security Info=True;User ID=sp_user;Initial Catalog=StoragePlatformReports;Data Source=SQLTESTDB\SQLEXPRESS;MultipleActiveResultSets=True\"
          providerName="System.Data.EntityClient" />
      <add name="ReportServer" connectionString=";Password=Password123;Persist Security Info=True;User ID=sp_user;Initial Catalog=StoragePlatformReports;Data Source=SQLTESTDB\SQLEXPRESS;MultipleActiveResultSets=True" />

5. Save the file and start the AccountServer service to test database connectivity. If there are any problems starting the AccountServer service, check the AccountServer logs and troubleshoot as appropriate.
6. Log in to the AccountServer using the Storage Platform Console to confirm that the correct backup account and Group information is present.
7. Configure the account database to back up from the separate SQL Server as explained in FAQ Article 423.