431 - Changing the Storage Platform and Storage Platform Reports database names

To rename the Storage Platform and Storage Platform Reports databases, follow the instructions below:

1. Stop the AccountServer service.
2. Using SQL Management Studio, connect to the database instance.
3. Expand the Databases tree. Right-click the Storage Platform database, and click Rename.
4. Enter the new name for the database.
5. Right-click the new database name and click Properties.
6. The Database Properties page will be shown. On the Files page, the Logical Names might need to be changed to match the database name. If these are not set, errors can result when trying to replicate to the Slave AccountServer.

   

7. Click OK to accept the changes.
8. Repeat the process for the Storage Platform Reports database.
9. With the Storage Platform Reports rename complete, expand the renamed Storage Platform database tree, and then expand the Views folder as shown below.

   

10. Right-click dbo.BackupTrace, and navigate to the following option:< >Script View as > ALTER To > New Query Editor Window.

    

    A new script window will open. 

    Look for the SQL statement that says "Select * from [StoragePlatformReports]..BackupTrace" 

    Change the StoragePlatformReports database name to match the new name (StoragePlatformReportsAF in this example).

    

    Click Execute to make the change to the database. 

    You now need to repeat the SQL edit for the following views:< >HsmTrace 

    MirrorSummary 

    MirrorTrace 

    RestoreTrace 

    RollupTrace 

    ServerTrace 

    When the renames are complete, the final step is to change the database names that the AccountServer is connecting to. On the AccountServer machine, navigate to the installation folder. Open ConnectionStrings.config and edit this as follows: 

    Change the DataService and BackupServer entries for the Account database. Set the Initial Catalog to the Storage Platform database name. The details used in this example are as follows:

    Data Source=SQLTESTDB\MSSQL
    Initial Catalog=StoragePlatformAF
    Password=Password123
    User ID=sa

    <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=sa;Initial Catalog=StoragePlatformAF;Data Source=SQLTESTDB\MSSQL;MultipleActiveResultSets=True"
        providerName="System.Data.EntityClient" />
    <add name="BackupServer" connectionString=";Password=Password123;Persist Security Info=True;User ID=sa;Initial Catalog=StoragePlatformAF;Data Source=SQLTESTDB\MSSQL;MultipleActiveResultSets=True" />
     

11. Change the ReportService and ReportServer entries for the Account database. Set the Initial Catalog to the new Storage Platform Reports database name. The details used in this example are as follows:
    Data Source=SQLTESTDB\MSSQL
    Initial Catalog=StoragePlatformReportsAF
    Password=Password123
    User ID=sa

    <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=sa;Initial Catalog=StoragePlatformReportsAF;Data Source=SQLTESTDB\SQLEXPRESS;MultipleActiveResultSets=True"
        providerName="System.Data.EntityClient" />
    <add name="ReportServer" connectionString=";Password=Password123;Persist Security Info=True;User ID=sa;Initial Catalog=StoragePlatformReportsAF;Data Source=SQLTESTDB\SQLEXPRESS;MultipleActiveResultSets=True" /> 
     

12. Save the file and start the AccountServer service. The AccountServer should now connect to the renamed databases.
13. If a Slave AccountServer is in use, the databases and connection should also be renamed to match the Master.