Restore a Backed-up MS SQL Server 2012 DB

Print this Topic  Previous Topic Home Topic Next Topic
You are here: Back-up and Restore > Restore a Backed-up Globodox DB > Restore a Backed-up MS SQL DB >Restore a Backed-up MS SQL Server 2012 DB

You can use the SQL Server Management Studio to restore your MS SQL Server 2012 based Globodox DB. You will require the latest Backup copy of the Master DB, i.e. the MainDB its cache file i.e. the MainDB_cache, all the MS SQL Server 2012 based Globodox DB along with their linked folder which contains the File Store to restore the DB's.

 

Note: You will need to have an existing DB or you will have to to create a blank DB to restore the data from the Backed up DB.
 

To Restore a Backed-up MS SQL Server 2012 based Globodox DB

1.Make sure Globodox is not running. Click Start > All Programs > MS SQL Server 2012 > SQL Server Management Studio. The SQL Server Management Studio will now be launched.
2.Enter your login details and connect to the server.
3.Select the Databases folder in the left pane, all the databases will now be displayed in the right pane.
4.Right-click any database from the list and select Tasks > Restore > Database... option. The  Restore Database window will be launched.
5.Select a DB from the To database drop-down to restore the backed-up DB. Incase you want to create a new DB to restore the backed-up DB then type the name of the DB in this box.
6.All the DB backups that were performed will be displayed in the From Database drop-down. Select a backup from the list to restore.
7.Incase the backup file is not listed in the From Database drop-down then select the From device option to specify the location of the back-up file. Click this [...]button to specify the location of the backed up file.
8.Once the backup file is selected the DB backup and the Transaction log back will be displayed in the Select the backup sets to restore section. Make sure both the back up of the DB and its Transaction log is checked.
9.Click the Options tab in the left pane. The options will now be displayed.
10.From the Restore options choose an appropriate option or leave it blank.
11.Select the RESTORE WITH RECOVERY option from the recovery state.
12.Click the OK button to begin the restore. Once the restore is complete you will get a confirmation message, click OK.
13.Now, select MainDB_cache from the list and follow step 4-8 to restore this DB.
14.Once you have restored MainDB and MainDB_cache, close the SQL Server Management Studio.
15.Now that you have restored the DB, you will now have to restore the DB's File Store i.e. its linked folder which contains the File Store.
16.Now, unzip this backed up folder that contains the File Store i.e. the MainDB folder and add it to the folder where Globodox databases are stored. This is usually the C:\Globodox Databases folder.
 
The DB is now completely restored and ready to use.
 
17.Start Globodox, click Settings > System Settings > DB List node... The DB List Manager will now be displayed.
18.Click the New button to add the restored DB to Globodox DB List. The DB Details window will now be launched.
19.Select MS SQL option from the DB Type drop-down.
20.Provide the machine name and the login details of the MySQL Server.
21.Once you are connected to the MS SQL server, all the DB's will be listed in the Globodox DB Name drop-down. Type the DB name or select the DB that you have restored from the Globodox DB Name drop-down and click the OK button.
22.When you open this DB, you may be prompted to specify the File Store for the DB. Point it to the 'C:\Globodox Databases' folder.
 
Follow the same steps to restore the other backed-up DB's
 
23.Now, unzip the multi-user.gdx file and paste it in  the ITAZ\Globodox folder created under the folder designated as the Common Application Data folder in your Windows installation.
For Windows Vista/Windows 2008/Windows 7/Windows 8/Windows Server 2012, this will be the C:\ProgramData\ITAZ\Globodox folder.
For Windows 2000/XP/2003 this will be C:\Documents and Settings\All Users\Application Data\ITAZ\Globodox
 

 

Notes:

Sometimes after restoration the DB is still in the restoring state. To solve this type the following in the Query window.

Restore database dbname With RECOVERY
Replace "dbname" with the name of the DB that you want to restore.
 

If you are restoring a database on another existing active database, you may get the following error.
 
"The backup set holds a backup of a database other than the existing 'Database Name' database".
 
To solve this type the following in the Query window....
 
RESTORE DATABASE dbname
       FROM DISK = 'C:\Backupdbname.bak'
               WITH REPLACE
 
where dbname is the name of the Database to which you want to restore the backed-up data.
and 'C:\Backupdbname.bak' is the location and the name of the backed-up file
 
The restore process may take some time depending on the size of the backed-up Globodox DB being restored.

Related Topics
Restore a backed-up MS SQL Server 2000 DB

Restore a backed-up MS SQL Server 2005 DB

 


Page URL: http://www.itaz.com/globodox/help/index.htm?restore_ms_sql_server_2012.htm