Difference between revisions of "Backup & Restore Databases - MS SQL"
(Created page with "*Please note that you will need to create your MSSQL database in the WCP before doing these steps # Log into the WCP at http://wcp.hostek.com/ # Click '''"MSSQL Tools"''' # S...") |
(How to restore an MS SQL database from a backup file.) |
||
| Line 1: | Line 1: | ||
| − | + | How to restore an MS SQL database from a backup file. | |
| + | |||
| + | ==Steps== | ||
| + | |||
| + | Steps to restore a database using myLittleAdmin through the control panel. | ||
| + | |||
| + | '''NOTE:''' You will need to create your MSSQL database in the WCP before doing these steps | ||
| + | |||
# Log into the WCP at http://wcp.hostek.com/ | # Log into the WCP at http://wcp.hostek.com/ | ||
| Line 13: | Line 20: | ||
# Click '''"Restore"''' and then click '''"Ok"''' on the alert message that pops up | # Click '''"Restore"''' and then click '''"Ok"''' on the alert message that pops up | ||
| + | |||
| + | ==Errors and Solutions== | ||
| + | |||
| + | Solutions to common errors when restoring database backups. | ||
| + | |||
| + | ===The backup file you selected exceeds the limit size of your database=== | ||
| + | |||
| + | '''Error Message:''' | ||
| + | The backup file you selected exceeds the limit size of your database. Restore has been cancelled. | ||
| + | |||
| + | This error indicates that the database that created the backup file is larger than the database you are restoring to. It is important to note that the size of the actual backup file does not matter. The size that is important is the size of both of the data file and log file of the database on the original SQL Server where the backup was created. If those file sizes are too large, you will need to reduce them before creating the backup file. | ||
| + | |||
| + | The most common issue is that the transaction log file is too large. To reduce the size of the transaction log file before creating the backup, you can perform a transaction log backup (Tasks -> Backup -> set '''Backup type''' = '''Transaction Log''') and then shrink the transaction log (Tasks -> Shrink -> Files -> set '''File type''' = '''Log'''). | ||
| + | |||
| + | |||
| + | __FORCETOC__ | ||
[[Category:Databases-MSSQL]] | [[Category:Databases-MSSQL]] | ||
Revision as of 17:44, 23 January 2013
How to restore an MS SQL database from a backup file.
Contents
Steps
Steps to restore a database using myLittleAdmin through the control panel.
NOTE: You will need to create your MSSQL database in the WCP before doing these steps
- Log into the WCP at http://wcp.hostek.com/
- Click "MSSQL Tools"
- Select your MSSQL database and database user from the dropdown menu
- Click "MyLittleBackup"
- Click "Restore Databases" from the left menu
- Select your MSSQL database
- Click "Ok" under the "Check the information about your database" heading
- Click "Browse" and navigate to the .bak file of your database on your local system
- Click "Ok"
- Select the database file you uploaded in the list and click "Ok"
- Click "Restore" and then click "Ok" on the alert message that pops up
Errors and Solutions
Solutions to common errors when restoring database backups.
The backup file you selected exceeds the limit size of your database
Error Message:
The backup file you selected exceeds the limit size of your database. Restore has been cancelled.
This error indicates that the database that created the backup file is larger than the database you are restoring to. It is important to note that the size of the actual backup file does not matter. The size that is important is the size of both of the data file and log file of the database on the original SQL Server where the backup was created. If those file sizes are too large, you will need to reduce them before creating the backup file.
The most common issue is that the transaction log file is too large. To reduce the size of the transaction log file before creating the backup, you can perform a transaction log backup (Tasks -> Backup -> set Backup type = Transaction Log) and then shrink the transaction log (Tasks -> Shrink -> Files -> set File type = Log).