I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration.
Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database has a back up of about 4 to 5 gig and all these happened in a space of a month after few changes here and there.
I noticed that the maintanance is running a full database and transaction log backup 2 diferent files every night and thouhg this could be part of the problem.
Other databases with similar settings for the back ups are fine, how do i stop this backup from expanding so quick.
I cant even copy these backups cause they are very large in size, how do i clear the log or whatever the solution may be??
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!