使用大型数据库 [英] working with large databases

问题描述

我们使用sql server 2008数据库和c#Windows应用程序.我们使用相同的数据库已有10年，因此数据库规模有所增加.我认为我们已经在软件中采取了必要的措施来加快数据库操作. sql服务器管理.例如，我们认为创建存档数据库.

1.我们备份当前数据库，
2.删除当前数据库中用于创建空白数据库的所有数据.

但是要用新旧数据实现此目的将需要打开两个连接.

SQL Server管理中是否有用于数据库存档的应用程序?

使用大型数据库的公司如何通过SQL Server找到解决此问题的解决方案?

Hi,

We use sql server 2008 database and c# windows application.We use for 10 years same database so increased in size of database.I think that we have received the necessary measures in Software To speed up database operations.We do not have too much experience in the sql server management.For example, We think create the archive database.

1.We backup current database,
2.delete all data from the current database used to create a blank database.

But to achieve this with the old and new data will need to open two connection.

Is there an application in SQL Server management for database archive ?

How do Companies working with large databases find a solution to this problem by SQL Server?

Thanks in advices.

推荐答案

您需要定义有关要归档哪些数据或要保留多长时间的数据的归档标准.现在，您可以将这些数据移动到单独的数据库或单独的文件组中.在第一种情况下，您必须连接到两个Db，而在第二种情况下，您不必这样做.清除完成后，运行所有索引，并使用dbccrinkfile压缩所有文件.这些链接可以为您提供更多有用的信息:
http://vyaskn.tripod.com/sql_archive_data.htm [ http://www.mssqltips.com/sqlservertip/1121/archiving-data-in -sql-server/ [ ^ ]

You need to define the archival criteria as to which data or how old data you want to archive. Now either you can move this data to a separate database or to a separate file group. In first scenario you would have to connect to two Dbs and in the latter you don''t have to do that. Once this purge is done run all your indexes and use dbcc shrinkfile to compact all the files. These links can provide you some more useful information:
http://vyaskn.tripod.com/sql_archive_data.htm[^]
http://www.mssqltips.com/sqlservertip/1121/archiving-data-in-sql-server/[^]

这篇关于使用大型数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！