The backup process can be done in two ways, namely:
- Using manual backup
- Using Enterprise Manager.
1. Manual
Manual backup requires attention to the following:
- You must know the location of the database file that has been used. By default the location is at
C:\Program Files\Microsoft SQLServer\MSSQLl\Data\. - You should know the SQL Server 2000 database file extensions. When creating a database, two types of files will automatically be created, namely: .MDF and .LOG.
The manual backup process is the same as copying and pasting files from Windows Explorer. From the SQL Server database location you can directly copy the .MDF and .LOG database files to another drive, such as D:\ or to a Flashdisk. To restore/restore, do the copy-paste process as you copy files.
2. Enterprise Manager
The backup process using Enterprise Manager has the following steps:
- Run Enterprise Manager Start >> Programs >> Microsoft SQL Server >> Enterprise Manager.
- Next, select Database. Next, select the database to be backed up, then right-click and select All Tasks >> Backup Database.
- In the SQL Server Backup window select Database -- complete >> Add.
- In the Select Backup Destination window, select File Name because the backup results will be saved in the form of a file. In that section, type the backup file name and enter the destination folder location for the backup, then click OK.
- After that, the backup storage location will be listed in the Destination, Backup to section, click OK, after which the backup process is carried out.
- When finished, click OK.