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.comTo 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 TierBack to
Frequently Asked Questions