|
|
Posted by @sh on 11/04/37 11:57
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.net> wrote in message
news:iaotf21jtp08f743267b5pppdlg8a6io4g@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 <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]
|