Restore a Backed-up MS SQL Server 2000 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 2000 DB

You can use the SQL Server Enterprise Manager to restore your MS SQL Server 2000 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 2000 based Globodox DB along with their linked folder which contains the File Store. Also see, Backup MS SQL Server 2000 DB

 

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 2000 based Globodox DB

1.Make sure Globodox is not running. Click Start > All Programs > MS SQL Server 2000 > 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 Restore as 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 Show backups of database drop-down. Select a backup from the list to restore.
Note:To specify the location of the backed up file, select that file from the list and click the Properties button. In the properties dialog click the Change... button to specify the location or type the location in the Restore from box.
7.Click the OK button to begin the restore. Once the restore is complete you will get a confirmation message, click OK.
8.Now, select MainDB_cache from the list and follow step 4-6 to restore this DB.
9.Once you have restored MainDB and MainDB_cache, close the SQL Server Management Studio.
10.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.
11.Now, unzip this backed up folder folder that contains the File Store i.e. the MainDB and add it to the folder where Globodox databases are stored. This is usually the C:\Globodox Databases folder.
 
The DB is now restored and ready to use.
 
12.Start Globodox, click Settings > System Settings > DB List node.
13.Click the New button to add the restored DB to Globodox DB List. The DB Details window will now be launched.
14.Select MS SQL option from the DB Type drop-down.
15.Provide the machine name and the login details of the MySQL Server.
16.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.
17.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
18.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, 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

For more info on restore see, Restore MS SQL Server 2000

 

Notes:

Incase you get the following error...
 
"The backup set holds a backup of a database other than the existing 'Database Name' database".
 
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 2005 DB

Restore a backed-up MS SQL Server 2008 DB

Restore a backed-up MySQL based Globodox DB

 

 


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