[Tutorial] Sql 2005

[janvier123]

Getting Started
The requirement for this guide is you have installed SQLServer 2005 Studio Express Edition
Also you are required to have a database backup on your harddisk.
First Step
Start your SQLServer Configuration manager, and login.
Then right click on the Databases folder to the left.
Click on Restore Database.
Select the Name for the databases like: account / billing / character / cash
In here write the name you wish to restore the database to, example my_restored_database. After this select From device as source, and click the button [...] to the right.
Choose your databases (account / billing / character / cash)
tick restote
Check the checkbox in Options in the menu to the left and tick write over existing database

ODBC Setup (not edited)
I'll just add a simple guide to how to setup ODBC on windows XP, as I belive it's close connected with the restoring. (English Windows XP, so you have to figure out what it's called if you're running a native version.)
Open the ODBC setup
Open your windows control panel
Select Administrative Tools
Select Data Sources (ODBC)
Select System DSN
Scroll to the bottom and select SQL Server
Setup of your ODBC
After doing this, you get a new interface op, here you'll write your server name, and perhaps a optional description.
For the Server you can typical just select a server, or write (local). In my case it's SUNNY\SQLEXPRESS as my computer is named SUNNY.
This also works over network, in case you're setting up a ODBC on another server than the SQLServer.
After this you press Next and get the following
Leave it to the above settings, and click Next
Now you'll get the following interface
Check the Change default database to and select your dk database..
Click Next and get the following interface
Swiftly skip this, and click 'Finish'. You'll possible get a window up asking you to test about it works. This is up to yourself, if you reached this far it surely allready works.