Note that the transaction log growing quickly is normal in a database that has a lot of inserts/updates. On 19 February 2014 17:44, Tusker 21 <tusker212@gmail.com> wrote:
Thanks @Jangita and @John. Will look at the current set configurations of the DB attribute types and lengths.
@Rad The current DB stands at 250Gib, the log file used to be bigger than the DB hence we run a Job to shrink the Log and the DB everyday as part of DB Maintenance. Shrinking is our8 temp solution of freeing any unutilized space and compressing the log
On Wed, Feb 19, 2014 at 5:25 PM, Rad! <conradakunga@gmail.com> wrote:
1) What do you mean by 'grows significantly' 2) WHY do you want to shrink it?
On Wed, Feb 19, 2014 at 3:59 PM, Tusker 21 <tusker212@gmail.com> wrote:
What is the best way to maintain a database that grows significantly. Currently i am using DBCC Shrink command. However this is said to have performance issues as the indexing of the DB is affected.
Any guru n the list who can assist?
R, T21
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke