使用大型数据库(working with large databases)

   IT问题网   2020-06-28 00:00:00

问 题

嗨,



我们使用sql server 2008数据库和c#windows应用程序。我们使用了10年相同的数据库,因此增加了数据库的大小。我认为我们已经收到软件中的必要措施加快数据库操作。我们在sql server管理方面没有太多经验。例如,我们认为创建存档数据库。



1.we备份当前数据库,

2.删除当前数据库中用于创建空白数据库的所有数据。



但是要实现这一点,新旧数据需要打开两个连接。



sql server管理中是否有应用程序用于数据库存档?



如何使用大型数据库的公司通过sql server找到解决此问题的方法?



感谢您的建议。

解决方案

您需要定义存档标准,以确定您想要的数据或旧数据存档。现在,您可以将此数据移动到单独的数据库或单独的文件组。在第一种情况下,您必须连接到两个dbs,而在后者中您不必这样做。完成此清除后,运行所有索引并使用dbcc shrinkfile压缩所有文件。这些链接可以为您提供更多有用的信息:

http://vyaskn.tripod.com/sql_archive_data。 htm[ ^ ]

http://www.mssqltips.com/sqlservertip/1121/archiving-data- in-sql-server /[ ^ ]

标签:使用大型数据库



分享:

  • 微信
  • QQ好友
  • QQ空间
  • 新浪微博


热门推荐

数据列表中的CountDown计时器(CountDown timers in a datalist)

problem im developing a auction website where students fr ...

插入记录器的问题(problem in inserting recorod)

problem cmd = new sqlcommand("insert into login1 values" ...

显示行到列(Display Row to Column)

problem how row to column value display in crystal report ...

Gridview中的复选框(Check box in Gridview)

problem if i check checkbox in gridview after that if i c ...

更新DatagridView记录(Updating DatagridView Records)

problem what am i doing wrong i can seem to u ...

如何从tortoiseSVN获取最新版本,然后使用CruiseControl.NET在msbuild中构建它(how to get latest version from tortoiseSVN and then build it in msbuild with CruiseControl.NET)

problem hi, i had a one asp.net solution in ...

请再帮忙,善良的人(Please help again, kind people)

problem hi all, so frustrated. i did two days'' researc ...

如何使用c#,net动态地在textarea中添加文本?(how to add text in textarea dynamically using c#,net)

problem string query = string.empty; query = "select mess ...

在Visual Studio 2010中创建Crystal Reports(Creating Crystal Reports in Visual Studio 2010)

problem im creating crystal reports using visual studio 2 ...

控制以填充数据并执行回发(control to fill the data and perform postback)

problem hi, is there any control to fill the data from da ...

System()vs CreateProcess()vs ShellExecute()(System() vs CreateProcess() vs ShellExecute())

problem here''s one for everyone, i''m running a batch fi ...

将TCL代码转换为C ++ ...(Convert a TCL code to C++...)

problem for {set i 128} {$ilt;256} {incr i 1} { eval lut ...

如何从二进制文件中读取浮点值(How Read Float value from Binary File)

problem hi. i do want to read float value from binary fi ...

使用.bak文件还原数据库(Restore Database using.bak file)

problem good evening everybody, please say how to restor ...

在gridview中显示总和(Show sum In gridview)

problem my gridview has data which looks like below (for ...

Ajax客户端脚本错误(Ajax Client side script error)

problem if (typeof(sys) === #39;undefined#39; ...

如何在UP和DOWN键进行编码(How to code at the UP and DOWN key)

problem i want to move picture box up and down when a use ...

如何计算excel 2003中的时间平均值(how to calculate time averge in excel 2003)

problem hii to all. if any body knows how to calculateave ...

控制相关问题(Control related issue)

problem respected sir, i have a page in which i m gettin ...

在运行时动态绘制div(draw div dynamically at runtime)

problem hiii all, i have a page which i draw all its attr ...