Please find below our step-by-step guideline of how migrate all data from old server to new one:
First way Back-up and restore DB:
1) Back-up your DeskAlerts database:
1.1) Go to SQL Management Studio and select your DeskAlerts database
1.2) Right click on DeskAlerts database and go to Tasks->Back up... in the appeared context menu
1.3) In 'Back up to' listbox you should specify output for your back up file. You have to click 'Add' and specify output path in appeared window
1.4) Click OK button and wait for database back up will be ready.
(for more information see this video: https://www.youtube.com/watch?v=eK526X3UhMM)
2) Restoring database
2.1) Copy you backup file (*.bak) from one machine to another where you new DB server is located
2.2) On machine with new DB server copy this file to Backup folder, default path is C:\Program Files\Microsoft SQL Server\MSSQL12.MSQSQLSERVER\MSSQL\Backup
2.3) Open SQL Management Studio, Right click on the Databases and select Restore Database...
2.4) Select Device as Source (2 radio buttons on the top of appered window)
2.5) Click 'Add' button and select your backup file
2.5) Click 'OK' button and wait for database will be restored
(for more information see this video: https://www.youtube.com/watch?v=mRI8vpn-tyk)
Please sign in to leave a comment.