这些DB是否需要？ [英] Are these DB's required??

问题描述

总是想知道，现在我有时间问 - 我们目前备份所有

数据库，这些似乎都在增长，MSDB BAK文件现在是

每个35mb，还在增长！我们可以从企业经理中删除这些吗？


- Master

- 型号

- MSDB

干杯，@ sh

解决方案

06.09.2006 16:05，@ sh写道：

总是想知道，现在我有时间问 - 我们目前备份所有

数据库，这些似乎都在增长，MSDB BAK文件现在是

每个35mb，并且还在增长！我们可以从企业管理器中删除这些吗？

等等，你刚才抱怨因为35MB？你一定是在开玩笑 - 或者用一块古老的硬件来赚钱...

- Master

- 型号

- MSDB

您有两种选择：


- 试一试

- 在手册中阅读它们


我会选择2 ...


问候


robert

NO！


主数据库是SQL的基石服务器

安装。拥有良好的备份至关重要。


我相信如果没有模型数据库，SQL Server将无法启动。一个

全新安装会创建一个，但有时候你想要b / b
对模型进行更改，并且你想要支持它们。此外，

型号是TINY。


MSDB包括备份的所有细节等。

MSDB是之所以增长，是因为每次备份都有记录。

你可能不需要回到第1天，并且有一个

标准工具可以删除在指定日期之前的条目：

sp_delete_backuphistory。详情请参阅文档。


Roy Harvey

Beacon Falls，CT


2006年9月6日星期三15:05:58 +0100，@ sh < sp ** @ spam.comwrote：

>总是想知道，现在我有时间问 - 我们目前备份所有
数据库和这些看起来大小都在增长，MSDB BAK文件现在每个35mb，并且还在增长！我们可以从企业经理中删除这些吗？

- 大师
- 型号
- MSDB

干杯，@ sh

那个不！是在回复原来的

帖子的问题时，我们可以从我们的企业管理器中删除这些吗？。


主题，这些DB是必需的吗？，是的！


Roy

2006年9月6日星期三14:54： 46 GMT，Roy Harvey< ro ******** @ snet.net>

写道：

> NO ！

主数据库是SQL Server安装的基石。拥有良好的备份至关重要。

我相信如果没有模型数据库，SQL Server将无法启动。一个
全新安装会创建一个，但有时你想要对模型进行更改，并且你想要支持它们。此外，
模型是TINY。

MSDB包括备份的所有细节。
MSDB正在增长，因为每次备份都有记录。
你可能不需要回到第1天，并且有一个
标准工具可以在指定日期之前删除条目：
sp_delete_backuphistory。详情请参阅文档。

Roy Harvey
Beacon Falls，CT

2006年9月6日星期三15:05:58 +0100，@ sh ; < sp ** @ spam.comwrote：

>>总是想知道，现在我有时间问 - 我们目前备份所有数据库而且这些似乎都在增长，MSDB BAK文件现在每个35mb并且正在增长！我们可以从企业经理中删除这些吗？

- 大师
- 型号
- MSDB

干杯，@ sh

Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

- Master
- Model
- MSDB

Cheers, @sh

解决方案

On 06.09.2006 16:05, @sh wrote:

Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

Wait, did you just complain because of 35MB? You must be joking - or
using an ancient piece of hardware...

- Master
- Model
- MSDB

You have two options:

- try it out
- read about them in the manuals

I''d go with option 2...

Regards

robert

NO!

The master database is the cornerstone of your SQL Server
installation. Having good backups is vital.

I believe SQL Server will not start if there is no model database. A
fresh install will create one, but there are times that you want to
make changes to model, and you woiuld want to back them up. Besides,
model is TINY.

MSDB includes, among other things, all the details of your backups.
MSDB is growing because there is a record of every backup ever run.
You probably don''t need this going back to day 1, and there is a
standard tool for deleting entries before a specified date:
sp_delete_backuphistory. See the docs for details.

Roy Harvey
Beacon Falls, CT

On Wed, 6 Sep 2006 15:05:58 +0100, "@sh" <sp**@spam.comwrote:

>Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

- Master
- Model
- MSDB

Cheers, @sh

That "NO!" was in response to the question that ended the original
post, "Can we remove these from our Enterprise Manager?".

The question in the Subject, "Are these DB''s required??", is YES!

Roy
On Wed, 06 Sep 2006 14:54:46 GMT, Roy Harvey <ro********@snet.net>
wrote:

>NO!

The master database is the cornerstone of your SQL Server
installation. Having good backups is vital.

I believe SQL Server will not start if there is no model database. A
fresh install will create one, but there are times that you want to
make changes to model, and you woiuld want to back them up. Besides,
model is TINY.

MSDB includes, among other things, all the details of your backups.
MSDB is growing because there is a record of every backup ever run.
You probably don''t need this going back to day 1, and there is a
standard tool for deleting entries before a specified date:
sp_delete_backuphistory. See the docs for details.

Roy Harvey
Beacon Falls, CT

On Wed, 6 Sep 2006 15:05:58 +0100, "@sh" <sp**@spam.comwrote:

>>Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

- Master
- Model
- MSDB

Cheers, @sh

这篇关于这些DB是否需要？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！