Are these DBs required?

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, @.shOn 06.09.2006 16:05, @.sh wrote:

Quote:

Originally Posted by

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...

Quote:

Originally Posted by

- 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" <spam@.spam.comwrote:

Quote:

Originally Posted by

>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 <roy_harvey@.snet.net>
wrote:

Quote:

Originally Posted by

>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" <spam@.spam.comwrote:
>

Quote:

Originally Posted by

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

|||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" <shortcutter@.googlemail.comwrote in message
news:4m844fF4umvpU1@.individual.net...

Quote:

Originally Posted by

On 06.09.2006 16:05, @.sh wrote:

Quote:

Originally Posted by

>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...
>

Quote:

Originally Posted by

>- Master
>- Model
>- MSDB

>
You have two options:
>
- try it out
- read about them in the manuals
>
I'd go with option 2...
>
Regards
>
robert

|||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" <roy_harvey@.snet.netwrote in message
news:iaotf21jtp08f743267b5pppdlg8a6io4g@.4ax.com...

Quote:

Originally Posted by

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 <roy_harvey@.snet.net>
wrote:
>

Quote:

Originally Posted by

>>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" <spam@.spam.comwrote:
>>

Quote:

Originally Posted by

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

|||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:

Quote:

Originally Posted by

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" <shortcutter@.googlemail.comwrote in message
news:4m844fF4umvpU1@.individual.net...

Quote:

Originally Posted by

On 06.09.2006 16:05, @.sh wrote:

Quote:

Originally Posted by

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...

Quote:

Originally Posted by

- Master
- Model
- MSDB

You have two options:

- try it out
- read about them in the manuals

I'd go with option 2...

Regards

robert

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

Quote:

Originally Posted by

>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|||Thanks guys, will have a read this weekend - what an exciting few days I
have in store ;o)

Cheers, @.sh

"Roy Harvey" <roy_harvey@.snet.netwrote in message
news:7tuuf2hat5dgjkakh3nsagbsd0fjcn7tp8@.4ax.com...

Quote:

Originally Posted by

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

Quote:

Originally Posted by

>>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 wrote:

Quote:

Originally Posted by

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.|||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

<cphite@.gmail.comwrote in message
news:1157656930.798184.59480@.b28g2000cwb.googlegro ups.com...

Quote:

Originally Posted by

>
@.sh wrote:

Quote:

Originally Posted by

>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.
>