|
|
Posted by Roy Harvey on 11/28/84 11:57
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:
>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.com> 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
>>
Navigation:
[Reply to this message]
|