Part 2 - Eneterprise Manager

1. Now we have SQL Installed, go to your Start menu and find "Enterprise Manager" under Microsoft SQL Server and run this.

Open the boxes up until you get to a Screen similar to this:

2. Highlight Databases, right click and you get some options, Pick "ALL TASKS", "RESTORE DATABASE"

 

3. Upon Selecting that you will get a Box up as such:

We now go Into the Various Database you need to restoring in Order for the 3G Server to run:

A. In the Restore as Database for EACH One you type as Follows:

Account

ConLog

CruelDragon3GbaseData

Game3G

Hero3G

Manage

B. Now After we type the Databse name, we press "From Device", Press Select Device. Press ADD and go find the Corresponding Database to restore.

C. Quite Often the database when backed up on one Computer was located in a Different Place to where you will want to restore this. If for example the Database used to Live on the D Drive under DATA - it will FAIL as you do not have a D Drive or a DATA Directory, SQL Will not make directories for you.

To Change this, Press Options on the Tab:

Type into here (or copy and Paste) the Location you wish the database to Live, myself I choose :

C:\Program Files\Microsoft SQL Server\MSSQL\Data\

And whatever the Database name is (in above example C:\Program Files\Microsoft SQL Server\MSSQL\Data\account_Data.MDF)

4. Now repeat the Process for each database until you have them all restored, Now Move onto ODBC Part.