΢͵Ӧ
MICROCOMPUTER APPLICATIONS
2000Vol.16No.1P.55-56



Microsoft SQL Serverݿⰲȫ
ͻָ
סΰ
ժҪݵĲԣݷMicrosoft SQL ServerϵͳʱЧĻָݣӶı֤Microsoft SQL Serverݵȫ
ؼʣݿ⡡ݡָ
AbstractThis paper discusses the back-up strategy of dif ferent computers, which is used to restore data efficiently in case of a crash o f the data server or MS SQL Server so as to guarantee the entirety and security of data in the MS SQL Server. 
Keywordsdatabaseback-uprestore
һ
Ϣķչ벻ݿ⼼ĲϷչdbaseFoxbaseFoxproAccess,Microsoft SQL ServerSybase SQL ServerOracleݿĹģԽԽ书ҲԽԽǿMicrosoft SQL ServerMicrosoft Windows NTϵһݿϵͳڶ̵߳Ŀͻ/ϵṹһеĶ̿ͻ/ݿϵͳ̵ͬ߳ݿϵͳ̵ݿϵͳȣװMicrosoft SQL Serverʱһ̣ÿûиԵֽ̣߳ṹҪԴȶϵͳٵöࡣMicrosoft SQL Serverǿܻ䱣֤ݵԣ˷άݵԣûٱҪŵĳԱ죬дӦóҲͳһȻӦóڲŬ֤ԣûбҪȫϣڴˣΪMicrosoft SQL ServerͿLANڲ֤ݿϢԺһԡMicrosoft SQL Server൥λӦãȻݿϵͳֹϵĿʼմڣҪǺݿеݡ
ϵĲ
ϵͳֹͣ磺
.е𻵣ĸֲ()ģеĹϿԡ
.ԴϣָһUPS޷쳣Դϡ
.Ȼֺˮֻ֣ԭɵعϡ
.ʹãͻӦóԼʹе;ϡ
.ƻһϵͳҲųһЩƻߡ
.жʽϼʽı塣
ûݱݣһ(Ҫϵͳ)ǾͲָܻʧݣĻòļݣһ£ǰЩϢ˶ٸҹʱݻڲϵĵûɲΪһЧı豸ͶһʽǱڵĲɻָҵϢԼǵıʱԵ΢
ݲ
ڱݿ׵ķֹ̹(Ҫϵͳ)ķЧĻָݣһֱȽϼ۵ıʽͬʱҲ򵥵ȷָܻ󲿷ϢķһıݲҪǺܶأ
.ڡ(ݵҪ򣬿ѡÿܡÿաÿʱб)
.ʹþ̬ݻǶ̬ݣ(̬Ҳݿʱб)
.ʹȫݻǹͬʹȫݺݡ
.ʹʲôʣ(ŴǴ)
.ʹ˹ݻƺõԶݳ
.鱸Եڡ
.ݴ洢ĿռǷԡŸš
.ǷָʵбݣǷбҪĵ¼źͿ
.ڸ𱸷ݺͻָҪԱȱϯ£Ƿܴǡ
Ȼı׼һݷʱݷ֧Microsoft SQL ServerУݿ⣬ϵͳûʻΪ־ݿתǱѸٵװصݷҪֹһʱ䣬ֻͶ뱸ݷɣݷӹ־ͺʲôҲûз
Ƿ󱸷ݣҲΪ˫ȱݣ⻹Ӳ̾󱸷ݣ(жͬӲ)ڳɱԭǣ˫ȱ(רʹһһļΪݷ)߽٣ݵĲԣҲõıݷʽرǵMicrosoft SQL SeverϵͳʱΪʱ˫ȱݿñݷֱʹ⣬ͨĸֱݲ(ݲ)װϵͳ(Microsoft Windows NT)װMicrosoft SQL Severݲԣ򲻱صģʱֻװMicrosoft SQL Severʱݻָɣǣ
ھڵκһ̨վϰװMicrosoft Windows NTMicrosoft SQL ServerڸûϽһеݿͬݿ⣬Microsoft SQL Serverϵͳṩ͹(Microsof SQL Enterprise ManagerеTools˵µDatabase/Object Transfer)ͨöʱ(ÿܡÿ¡ÿջÿʱ)ɼԶİѷݿݴ͵ùվݿУһ(ϵͳ)Microsoft SQL ServerϵͳʱֻҪװϵͳ(Microsoft Windows NT)װMicrosoft SQL ServerȻԲ͹ͨùվݴMicrosoft SQL ServerݿУȷݵİȫָϺʿ﹫˾ʹһڶӻҲ֤ݲʧ
⣬ڵİĳЩݣĳЩȫݱݵ̣УڱյİȫҲʧΪһֺ÷
ġ
ݿİȫ/ָԹȻж֣Microsoft SQL ServerݿϵͳʱԭȵıݺѻָΪMicrosoft SQL ServerݿⲻFocproݿֱӿļǰ߱Ҫбݲԣܰȫָˣڴ쳣ʱݲԣѾյЧֻҪʵЧı/ָʩݿMicrosoft SQL Serverܹȫġ
ߵλ(ϺѧԶѧԺ Ϻ200070)
ΰ(ѧ Ϻ 200433)
οף
1Jeffy L. Byrne,<<Microsoft SQL Server6.5Աֲ>>еҵ硡1998
2ׯ졡ݿϵͳܽ΢͵Ӧá1999.2
ոڣ1999-09-14
