Setting Up The Microsoft SQL Server 2000

nightx · Admin Data inscrierii: 17/Aug/2007 Mesaje: 159

Chapter.00

01.I Use '' '' For Some Things Don't Copy Things Whit Those Signs.

02.Before We Start I Use ''C:\'' Drive As Default In This Guide. (If U Have A Drive Name Called ''D:\'' Or ''E:\'' Or Whatever U Just Need To Canghe ''C:\'' To Ure Drive Name, So Easy)

03.My ''MuOnline'' ''Database'' Is Located In ''C:\MuServer\MuOnline'' In This Guide.

04.My ''MuOnline'' ''Backup Database'' Is Located In ''C:\MuServer\MuOnline BACKUP'' In This Guide.

05.My ''Ranking'' ''Database'' Is Located In ''C:\MuServer\Ranking'' In This Guide.

06.My ''Ranking'' ''Backup Database'' Is Located In ''C:\MuServer\Ranking BACKUP'' In This Guide.

Chapter.01

01.Download Microsoft SQL Server 2000: Here

02.Afther U Downloaded Microsoft SQL Server 2000, Extrackt It In ''C:\Program Files\Microsoft SQL Server''

03.Run ''C:\Program Files\Microsoft SQL Server\setup.bat''

04.Klick ''Next''

05.Click ''Next''

06.Click ''Next''

07.Click ''Next''

08.Click ''Yes''

09.Click ''Next''

10.Click ''Next''

11.Click ''Next''

12.Click ''Use the Local System account''

13.If U Want A Password On U ''sa'' Login, Click ''Mixed Mode'' And Typ Twice The Same Password And Click ''Next''.If U Dont Want A Password On U ''sa'' Login, Just Click Next

14.Click Next

15.Click Finish

Chapter.02

01.Afther ''Chapter.01'' Click On ''Start'' > ''Programs'' > ''Microsoft SQL Server'' > ''Service Manager'' And U Will See Server ''U COMPUTER NAME'' And Services ''SQL Server'' Then Click Start/Continue (If U Want Let It Start Automatic Click ''Auto-start service when OS starts'')

02.Then Click On ''Start'' > ''Programs'' > ''Microsoft SQL Server'' > ''Enterprise Manager''

03.Then U Will See This ''Console Root'' Root''
''SQL Server Group''
''(local) (Windows NT)''
Then Click On ''(local) (Windows NT)'' > ''Databases'', Then Right Click On ''Databases'' And Click New Database... ''Name:'' ''MuOnline'' And Then Click ''OK''

04.Then U Will See ''From device'' Then Click ''Select Devices'' > ''Add'' Then Click On ''...'' Click ''C:\MuServer\MuOnline BACKUP'' And Dublu Click On ''MuOnline''

05.Click ''OK''

06.Click ''OK''

07.Click ''Then Click ''Options'' And If U Did That Click On ''Force restore over existing database''

08.Then U Should See This: (If U Don't See This This Just Canghe To This)
''Logical file name'' ''Move to physical file name''
MuOnline_dat ''C:\MuServer\MuOnline_data.mdf''
MuOnline_log ''C:\MuServer\MuOnline_log.ldf''

09.Click ''OK''

10.Now U Finishd ''Restoring'' The ''MuOnline'' ''Database''

11.Now Exit ''Enterprise Manager'' And Read Chapter.03

Chapter.03

01.Afther ''Chapter.02'' Click On ''Start'' > ''Programs'' > ''Microsoft SQL Server'' > ''Service Manager'' And U Will See Server ''U COMPUTER NAME'' And Services ''SQL Server'' Then Click Start/Continue (If U Want Let It Start Automatic Click ''Auto-start service when OS starts'')

02.Then Click On ''Start'' > ''Programs'' > ''Microsoft SQL Server'' > ''Enterprise Manager''

03.Then U Will See This ''Console Root'' Root''
''SQL Server Group''
''(local) (Windows NT)''
Then Click On ''(local) (Windows NT)'' > ''Databases'', Then Right Click On ''Databases'' And Click New Database... ''Name:'' ''Ranking'' And Then Click ''OK''

04.Then U Will See ''From device'' Then Click ''Select Devices'' > ''Add'' Then Click On ''...'' Click ''C:\MuServer\Ranking BACKUP'' And Double Click On ''Ranking''

05.Click ''OK''

06.Click ''OK''

07.Click ''Then Click ''Options'' And If U Did That Click On ''Force restore over existing database''

08.Then U Should See This: (If U Don't See This This Just Canghe To This)
''Logical file name'' ''Move to physical file name''
Ranking_dat ''C:\MuServer\Ranking_data.mdf''
Ranking_log ''C:\MuServer\Ranking_log.ldf''

09.Click ''OK''

10.Now U Finishd ''Restoring'' The ''Ranking'' ''Database''

11.Now Exit ''Enterprise Manager''

Chapter.04

U Have Done This Guide Very Well !!!!! Congratulations !!!!!

More Great ''Guides'' Of Me Coming Soon !!!!!