摘要：隨著數據庫技術的不斷發展，數據庫的規模越來越大，其功能也越來越強大。互聯網技術的飛速發展，使企業的信息數據量也急劇增長。因此提高數據的安全性和數據恢復能力一直是關注的焦點。實現一套安全的，方便的，自動的，經濟的備份恢復系統非常有實際價值。
數據庫系統作為信息系統中的基礎軟件，其安全性問題十分重要。目前國內的數據庫系統基本采用國外產品，必須確保對其進行安全利用和有效監控。本文在對數據庫系統安全相關理論和技術進行探討的基礎上，基于安全性增強的思想，對SQL Server 2000數據庫的應用系統的安全增強進行了研究和探討。
本論文主要研究了目前信息安全的研究與發展以及數據庫安全的現狀；多角度地分析了數據庫系統的安全性威脅和數據庫安全性的基本要求。以SQL Server數據庫為實例，對SQL Server數據庫基于角色的權限管理，訪問控制，審計監控、增量備份和數據恢復等關鍵性技術進行了深入研究。 主要基于SQL Server數據庫系統，對數據庫存儲及傳輸加密、用戶口令認證，安全審計機制等給出了技術實現，并通過存儲過程、函數和程序包的方法對現有的數據庫系統安全功能加以改進。在Visual C++和SQL Server 2000數據庫的開發環境下，實現數據庫的異地自動備份和恢復功能。
關鍵詞：數據庫、 VC、 安全性、備份、 恢復
Abstract:Along with the database technology development，the scale of Database become larger and larger. Their functions are increasingly powerful. Internet technology is developing at full speed，Enterprise information and data was also rapid growth. Therefore improve data security and data recovery capability has been the focus of attention. Achieving a safe, convenient, automatic, economic system of backup and recovery demonstrates very practical value.
As foundation software of information system, it is significant for its security. Now most database systems use foreign product in our country. It should be solved how to ensure secure use and audit effectively. Based on a plenty of papers, technology reports and dissertations, this dissertations make some research work on the field of secure theory and technology and study on secure enhancement based on SQL Server database system.
The dissertation mainly studies in the current information security and the database security status. The characteristics and fundamental requirement of database security issues are proposed. For SQL Server database, the aspects of privilege admin based on roles, the granularity access control, audit and backup and restore technology are discussed. Based on SQL Server database, database storage and transmit authentication, users password authentication, secure audit are realized. Database security functions improve by procedure, function and program packages. In Visual C + + and SQL server 2000 database development environment, accomplish database automatic backup and recovery functions.
Keywords: Database、VC、Security、Copy、Restoration
