BACKUP & RESTORE DATABASE SQL SERVER 2000 A. BACKUP DATABASE 1. Open “Enterprise Manager”. Click “IT102 > Databases > Northwind > All Tasks > Backup Database...”. Choose Backup : “Database - complete”. Then Click “Add”

1

2. Click “...”

3. Input “File name”, example : Northwind-20100413-1114.bak Click “OK”

2

4. Click “OK”

5. Click “OK”

3

6. For check, there is result file backup : Northwind-20100413-1114.bak

4

B. RESTORE DATABASE 1. Open “Enterprise Manager”. Click “IT102 > Databases > Northwind > All Tasks > Restore Database...”.

2. Choose Restore : “From Device”. And Restore backup set : “Database – complete”. Click “Select Devices...”.

5

3. Click “Add”

4. Click “...”

6

5. Choose file backup : Northwind-20100413-1114.bak Click “OK”.

6. Click “OK”.

7

7. Click “OK”.

8

8. Click Tab “Options”. Important : a. Tick for “Force restore over existing database”. b. check for path file northwnd.mdf and northwnd.ldf Click “OK”.

--- End of Documents ---

9