How do I complete a database restore in Management Studio Express 2008?
Modified on Tue, 22 May 2012 10:25 by CAREWare Help Desk — Categorized as: FAQ
CAREWare is able to restore databases up to 1.5 GBs in size. When trying to restore databases larger than that size CAREWare will freeze and mark the database as suspect. In order to restore a backup file larger than 1.5 GB in size a user will need to restore the individual databases required for CAREWare using a SQL Manager such as Management Studio Express.
Note
: You can download Management Studio 2008 Express from
Microsoft.com
To complete a restore using Management Studio Express 2008
Open Management Studio Express 2008
Connect to the CAREWare instance using the SA account or Windows Authentication
Expand Databases
Right click on CW_Data
Select Tasks>Restore>Databases
Check the check box for From Device
Click Add
Browse to the location of the backup file * Make sure to chose All Files (*.*) from the Files of Type pull down menu
Highlight the CAREWare backup (*.cwb) and press OK
Press OK
Select the backup to restore by checking the Restore check box for the CW_Data database
Click on Options on the Select a Page column in the upper left corner
Check the Overwrite check box in Restore Options
Press OK
When the restore completes successfully click OK
Click New Query to open a new query window
Run the following query: Use CW_Data exec sp_changedbowner 'cwbt'
Restart the business tier service
*
Login to CAREWare as normal
Back to the
Data Tier
Back to
Frequently Asked Questions