Restoring an SQL database using SQL Server Management Studio

This support note applies to:

AO Tax (NZ)
AO Practice Manager (NZ)
AO Practice Manager (AU)
AO Tax (AU)
AE Document Manager (NZ)
AE Practice Manager (NZ)
AE Practice Manager (AU)
AE Document Manager (AU)
AE Tax (NZ)
AO Corporate Compliance (AU)
AE Tax Series 6 & 8 (AU)
AE Tax (AU)
AE Corporate Compliance (AU)

Article ID: 34002

The steps below will step you through restoring an SQL database using Microsoft SQL Server Management Studio.

To restore a database in SQL Server Management Studio

Follow the menu path: Start > Programs > Microsoft SQL Server 20xx > SQL Server Management Studio.
In the Connect to Server window, enter the login details as required, then click Connect.
From within SQL Server Management Studio, right-click on the Databases folder and select Restore Database.
From the Restore Database window, select From device then click the ellipsis button and click Add.
Browse to the location of your backup, highlight the item and click OK.
Click OK again to the Specify Backup window.
In the Restore Database window, ensure the To Database field is correct and select the Restore option.
Navigate to Options and select the Overwrite the existing database (WITH REPLACE) option. Then click OK to restore the database. The Restore of database completed successfully window appears.
Click OK. The database has been restored successfully.

If you have issues performing the MS SQL Server Management Studio restore process, please contact your IT provider.

Once you have successfully restored the database, you will need to run the Create User.sql script or you will not be able to log in. For details and a copy of the script, refer to Running the Create user.sql script