As the flying development of information age and Internet technology, the information data bulk of the enterprise grows quickly also. The data that how avoids arise suddenly destroys (be like: Breakdown of assault of hacker attack, virus, hardware and person wait to be operated by accident) , raising the security of data and data to restore ability is user and the focus that the manufacturer pays close attention to all the time. Backup is to restore data to be mixed the most easily the most effective assurance method, backup should undertake regularly, carry out active data management.

The SQL Server of Microsoft company is the database management system with a perfect function, because be not had with Windows operating system,seam union, the operation is handy easy travel, application is very wide. Will have a look at the effective method that the backup of the SQL Server 7.0 that is based on NT and data restore below.

Be aimed at server system

Because database server is medium the system of installation is more, the setting is complex, be like occurrence hardware breakdown, criterion must reshipment system, restore to install, because this is necessary,logarithm undertakes backup according to library server.

1, the function that use NT Server provides

In prevent data to lose a respect, the disk management appliance of NT has powerful function, it supports RAID the 0th, 1, 5 class. Among them RAID 1 class is to point to the some partition that gets on a driver to go up in another build a mirror. When undertaking writing operating, data will keep same data to the middle of two disk, read when taking can read at the same time from two disk take. When driver damages, will undertake resumptive by its mirror.

2, use tool of tripartite backup

The backup software that uses other company will do backup to server system. The disk backup tool that the author is commonly used is Norton company -- Ghost. A certain partition that can get on disk directly or clone of whole hard disk become this software file of a mirror, deposit it next elsewhere, so when this partition or hard disk occurrence problem is destroyed even when, use Ghost is on another hard disk or partition, use mirror document fast and reductive.

Be aimed at SQL Server

1, undertake on this locality machine the database backs up

Affirm whether SQL Server service has been started first, if was not started, in using bill of fare of program of SQL Server 7.0 " SQL Server Service Manager " undertake starting, open next " Enterprise Manager " , spread out left SQL Server Group, in spreading out SQL Server " Databases " , click right key, choose in menu " all tasks " in option " Backup Database " child option, if pursue,appear the database backup picture of 1.



Graph 1


After picking the database that wants backup and backup way, click [Add] pushbutton, good in the setting in the dialog box deposit catalog and file name, click [OK] pushbutton. If want to install fixed and automatic backup, can be in " Schedule " in setting, after ending, click [affirmatory] pushbutton, database backup began to carry out.
Previous12 Next

Previous:Fat12, fat16, with Fat32
Next：About 7 of system of NTFS disk file wonderful interlocution