Posted by Erland Sommarskog on 11/24/06 22:43

sifrah (sifrah@walla.com) writes:
> Thanks for the informative response.
> The old administrator didn't back up the DB and log on a regular basic
> and that why I got all this mass.
>
> To resolve the issue, i did a backup for the DB and log a few times
> until the space cleared from the HDD.
>
> To prevent the issue from happening again i set a maintenance plan to
> do a backup every night on top of my backup exec backups.
>
> Do you think it's ok?

You did include a backup of the transaction log in the maintenance plan,
I hope?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How to build a procedure that returns different numbers of columns as a result based on a parameter
• Prev in forum: Re: DTS - Need to Set Destination Filename dynamically
• Thread view: Re: HDD still full after shrinking transaction log

[Reply to this message]