[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

SQL 2005 Maintainence Plan

Asked by krishnamus in Databases Miscellaneous, SQL Server 2005

Tags: SQL 2005

a> For the backup of our SQL 2005 Database file we create one maintenance plan/instance. This plan will take backup as a form of .bak and .trn and it will do the cleanup of two days old  .bak and .trn files. We have observed that it is taking the backup abut cleanup is not performed and this in turn fill the disk space.

Please suggest on this.

b> How should we estimate the disk space required to keep the database files (.mdf, .ldf) and one day's backup in place.

[+][-]11/04/09 10:46 PM, ID: 25747228Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 08:15 PM, ID: 25756574Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/08/09 08:18 PM, ID: 25773359Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625