Posted on 2012-03-12
We have maintenace plan which runs each day at 10 pm which includes full backup of all the user database and transaction log backup scheduled at same time. Is it gud practise to do so. does it necessary to perform log backup after full backup?
This is only t-log backup we have at the same time with full backup . but the order of backup in full then log.
my another question is in the above maintenace palne my full backup get sucessed yesteday but it t-log backup have been failing form last 3 days. Moreover, my full backup was also failed day before yesterday and 2 days before alone with t-log backup. Because of that my f: contains only few MB left which is the log file location for all the user database. In such
situation what should by my approach to increase the disk space ?
Thanks in advance