問題描述
我正在尋找一種解決方案來存檔我的數據庫中存在的數據.我的數據庫是 SQL Server 2008，大約有 250 個表.我在網上搜索并找到以下鏈接:http://www.dbazine.com/sql/sql-articles/charran13/
I'm looking for a solution to archive data that exists in my database. My database is SQL Server 2008 and have approximately 250 tables. I search web and find the below link : http://www.dbazine.com/sql/sql-articles/charran13/
但是這個解決方案不清楚
but this solution is not clear
我不知道在 sql server 中有沒有直接的方法可以做到這一點.請給我一個解決方案.
I don't know that is there a direct way for doing this in sql server. please give me a solution.
推薦答案
您選擇推出的解決方案將取決于您實施數據歸檔的原因.
The solution that you choose to rollout will be dependent on your reasons for implementing data archival.
例如，您需要考慮:
要歸檔哪些數據?
例如所有數據或舊數據超過某個日期?
For example all data or data older than a certain date?
這對大多數人都有影響合適的歸檔技術使用，即是否是完整的數據庫備份就足夠了專門構建的歸檔過程使用 SQL Server 集成服務可能更合適.
This has implications for the most suitable archive techniques to be used, i.e. whether a full database backup could suffice or perhaps a purpose built archiving process using SQL Server Integration Services may be more suitable.
歸檔數據需要具有多大的可訪問性?
歸檔數據是否需要立即可用，也許在較慢的 SATA 存儲，或者可能是幾天的時間來獲得訪問數據是否可以接受?也許如果恢復時間很長自由然后一個完整的數據庫備份，定期服用，說一次一個月就夠了.如果在另一方面，數據需要非常手頭有很多，然后是解決方案.
Does the archived data need to be immediately available, perhaps on slower SATA storage or perhaps a period of several days to acquire access to the data is acceptable? Perhaps if the restore time is quite liberal then a FULL database backup, taken at regular intervals, say once a month could suffice. If on the other hand the data needs to be very much on hand then a solution.
數據要求的安全含義是什么?
例如，備份應該是加密或是否正在存儲數據異地是否有足夠的體力安全到位?
For example, should backups be encrypted or if data is being stored offsite is there adequate physical security in place?
也許如果您能提供更多關于您希望存檔數據的原因以及希望存檔多少數據的詳細信息，那么我們或許可以提供更具體的指導.
Perhaps if you could provide some more details as to your reasons for wishing to archive your data and also how much of your data you wish to archive, then we may be able to provide more specific guidance.
這篇關于SQL Server 數據存檔解決方案的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！