Everything about database,how to,example,guide,

Undertaking backing up must establishing backup facility above all before.The memory medium that backs up equipment is to use log of memory database, general affairs or file and file group to back up.Backup equipment can be hard disk, tape or conduit.SQL Server supports only back up the database to this locality magetic tape station,is not the long-range magetic tape station on the network.When use disk,The hard disk that SQL Server allows to board hard disk of this locality lead plane and long-range lead plane regards backup as equipment,Those who back up equipment is the means memory with the file in hard disk.

15.2.1 manages backup facility with SQL Server Enterprise Manager
1 uses SQL Server Enterprise Manager to establish backup facility
(1) use SQL Server Enterprise Manager,The measure that establishs backup facility is:
(2) open Management folder,Choose Backup icon next.
(3) right attack Backup to choose option of New Backup Device in playing a menu,Shoot a dialog box of New Device of - of BackupDevice Properties next.Place of the 15-1 that be like a graph is shown.

(4) equipment name is inputted in Name column the logistic name that this name is backup equipment.
(5) type of choice backup equipment,If choose File Name to state use hard disk is done,back up,The facility that establishing only is hard disk file when,This option just acts well.If choose Tape Drive Name to express to use tape device.When the tape equipment that backing up in what found equipment is with this locality the server is linked together only,This option just acts well.
(6) click next establish backup facility certainly.

2 use SQL Server Enterprise Manager deletes backup equipment in the second condition that establishs backup facility,After icon of pitch on Backup,Right in right pattern dialog box attack the backup facility that should delete,In option of Delete of the choice in playing a menu,Delete this backup equipment.

15.2.2 uses systematic process to manage backup facility
1 Sp_addumpdevice
In SQL Server,Use Sp_addumpdevice will establish backup facility.Its grammar format is: