Steps for migrating the Appstream database to a new SQL server:
Phase 1: Database backup:
- Open Streaming Console to the Monitor>Components page then STOP the STE service and all DA components
- Login to the old SQL server
- Open SQL Server Management Studio and expand Databases
- Right-click on the Appstream database, point to Tasks and then click Back Up...
- Verify the database name and select Backup type: Full
- Choose the destination for backup & click OK
- Ensure the backup of the Appstream database completed successfully
- Copy the *.bak file to new SQL server
Phase 2: Database restore:
- Login to the new SQL server
- Open SQL Server Management Studio and expand Databases
- Right-click on Databases and click New Database..., name the new database “Appstream”, click OK
- Right-click the Appstream database, go to Tasks>Restore>Database..., which opens the Restore Database window
- On the general page, select From device: then click ...
- Click on Add and specify the backup file (*.bak) that was copied over from the old SQL server, click OK and then click OK
- Enable the checkbox under Restore for the backup file that was just specified
- Open the Options page on the right side to select the restore options
- Enable Overwrite the existing database (WITH REPLACE)
- Click OK and ensure the restore of Appstream database completes successfully
Phase 3: Mapping ASUSER to the restored Appstream Database:
- Execute the following SQL query to map the asuser login to the Appstream database
Use [Appstream]
Go
--This will report all the orphaned logins
EXEC SP_CHANGE_USERS_LOGIN @ACTION='REPORT';
--This should fix an orphaned user
EXEC SP_CHANGE_USERS_LOGIN @ACTION='UPDATE_ONE', @USERNAMEPATTERN= [ASUSER] , @LOGINNAME=[ASUSER]
- Now expand Security>Logins, right-click asuser and open Properties
- Compare & verify the asuser’s mapping and other login properties with those on the old SQL server
Phase 4: Transferring the STE DB source to SQL 2008 box:
- Open the streaming server console
- Ensure all component statuses are green
- Go to C:\symantec\workspace streaming\server\streamletengine\da\conf\
- Copy the da.conf file and paste a backup in a different location
- Open the real da.conf file then find and modify the following lines:
torque.database.appstream.adapter=msSQL
appstream.database.host=REPLACE THE OLD SQL HOSTNAME WITH THE NEW SQL HOSTNAME
appstream.database.port=1433
- Save and close the da.conf file
- Open the console and restart the STE
Phase 5: Verifying SQL migration:
- Open the console and verify STE status (database is [up])
- Check the streaming performance on end user machines
- Run any report and verify the output
- Rename the Appstream database to Appstream_old in the old SQL server or shutdown the old server