|
|
Posted by Roy Harvey on 11/28/86 11:57
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]
|