Once you have purchased our VPS plan, you can the instructions below to restore your database to our server.
1. Before starting, you will need to copy the SQL backup file (typically
has a .BAK extension)
2. Upload database backup file to server via FTP
2. Open SQL Server Management Studio and login to the SQL Server you want to restore the database to as windows authentication
3. Once logged in, expend the Databases folder and right click the database and select "tasks" -->"restore"-->"file and filegroups" and select From device from Source for restore
4. Set ‘File’ as the backup media type and then click ‘Add’.
5. Browse to the SQL backup (BAK) file you want to restore.
6. Next, select the restore point you want to use. Since a SQL backup file
can hold multiple backups you may see more than one restore point
listed.
At this point, enough information has been entered for the database to
be restored. However, SQL backup files store information about where
data files are copied so if there are any file system problems such as a
the destination directory not existing or conflicting data file names
an error will occur. These problems are common when restoring a backup
created on a different SQL Server installation.
7. To review and change the file system settings, click the Options page on the left in the Restore Database dialog.
On the options page, you will want to make sure the ‘Restore As’
column points to valid folder locations (you can change them as needed).
The the files do not have to exist, however the folder path must exist.
If the respective files do exist, SQL Server follows a simple set of
rules:
- If the ‘To database’ (from the General page) matches the restore
database backup (i.e. restoring to matching databases), the respective
files will be overwritten as part of the restore.
- If the ‘To database’ does not match the restore database backup
(i.e. restoring to a different database), the ‘Overwrite the existing
database’ will need to be checked for the restore process to complete.
Use this function with caution as you can potentially restore database
backup information on top of data files from a completely different
database.
Generally, you can tell the databases differ based on the ‘Original File
Name’ which is the internal name SQL Server uses to reference the
respective files.
8. Once your restore options are set, click Ok.
Article ID: 1541, Created: December 16, 2013 at 12:05 AM, Modified: December 16, 2013 at 12:05 AM