Are these DB's required??

[@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

[Robert Klemme]

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

[Roy Harvey]

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

[Roy Harvey]

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

[@sh]

Instead of being so f*cking anal you could actually advise me, if I had
manuals I would have read them, else I wouldn't be posting here...we have a
dedicated server, with no manuals, hence my newsgroup post.

Could anyone else be so kind as to help?

Cheers, @sh
"Robert Klemme" <sh*********@googlemail.comwrote in message
news:4m************@individual.net...

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

[@sh]

Many thanks Roy, greatly appreciate your help! Guess I'll be leaving them in
place, we simply out of policy backup everything and question what we've got
later, its only now that we've had time for a cleanup, hence my questions.

Thanks again.

Cheers, @sh
"Roy Harvey" <ro********@snet.netwrote in message
news:ia********************************@4ax.com...

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

[SQL Menace]

In enterprise manager, the 10th icon from the left (looks like a yellow
question mark over a book). If you click on this it will open BOL
(books On Line) That is the manual that comes with SQL server

Denis the SQL Menace
http://sqlservercode.blogspot.com/
@sh wrote:

Instead of being so f*cking anal you could actually advise me, if I had
manuals I would have read them, else I wouldn't be posting here...we have a
dedicated server, with no manuals, hence my newsgroup post.

Could anyone else be so kind as to help?

Cheers, @sh
"Robert Klemme" <sh*********@googlemail.comwrote in message
news:4m************@individual.net...

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

[Roy Harvey]

On Wed, 6 Sep 2006 16:02:44 +0100, "@sh" <sp**@spam.comwrote:

>if I had
manuals I would have read them

The "manuals" are Books on Line, not printed. It should have been
installed with the SQL Server tools. In any case they can be
downloaded (for 2000 and 2005 at least) from the Microsoft web site.

You can NOT operate without consulting Books on Line. Constantly.

Roy Harvey
Beacon Falls, CT

[@sh]

Thanks guys, will have a read this weekend - what an exciting few days I
have in store ;o)

Cheers, @sh
"Roy Harvey" <ro********@snet.netwrote in message
news:7t********************************@4ax.com...

On Wed, 6 Sep 2006 16:02:44 +0100, "@sh" <sp**@spam.comwrote:

>>if I had
manuals I would have read them

The "manuals" are Books on Line, not printed. It should have been
installed with the SQL Server tools. In any case they can be
downloaded (for 2000 and 2005 at least) from the Microsoft web site.

You can NOT operate without consulting Books on Line. Constantly.

Roy Harvey
Beacon Falls, CT

[cphite]

@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?

- Master
- Model
- MSDB

Cheers, @sh

1. Do NOT delete them.
2. Keep backing them up.
3. Go to books online and read about what these databases are for and
why you should keep them and back them up.

[@sh]

Many thanks, had a brief read about their purposes last night via the Books
Online that I've now discovered thanks to the responses here.

Cheers, @sh
<cp****@gmail.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...

>
@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?

- Master
- Model
- MSDB

Cheers, @sh

1. Do NOT delete them.
2. Keep backing them up.
3. Go to books online and read about what these databases are for and
why you should keep them and back them up.