PHONE 1300 138 046  Australian Owned and Operated  All prices in Australian Dollars

Knowledgebase

Portal Home > Knowledgebase > Windows clients > SQL Server > Backing up and Restoring SQL Server Database

Backing up and Restoring SQL Server Database

To backup SQL Server database open its properties screen:

and then click Backup button:

Specify backup name and select preferred method for storing backup. You could download it immediately or copy to some folder within your hosting space.

Control panel produces SQL Server backups in BAK format. Resulting file could be very large (it depends on actual size of database and its transaction log), but you have an option to compress it by ticking ZIP Backup option.

To restore SQL Server database click Restore button on database properties screen:

Click Browse... button to select backup file from your local file system or tick Hosting Space File option and then pick backup file from hosting space file system.

Click Restore to finish restoration wizard.

To reduce the size of SQL Server database data and log files, you can truncate database files. To truncate database files click Truncate Files button on database properties screen.

 

Was this answer helpful?

Add to Favourites Add to Favourites Print this Article Print this Article

Also Read