I would suggest that you create a number of tasks to re-index/compact/shrink those databases. We have a number of SQL databases, and I set up Maintenance Plans to do this. I also have a Maintenance Plan to backup full and incremental daily, then delete after x number of days. If you are interested I can send you screen shots off-list if you have interest. Your comment on the transaction logs is interesting. Are these all current or old? Generally you'd have just a current set of logs and run backup on them, scripted or otherwise, at least once a day. Tom
>>> Don Ely <[email protected]> 12/23/2010 10:29 AM >>> Well, you can either go into SQL Mgmt Studio, right mouse click the DB, go to tasks and select shrink files OR you can go to the query tool and run DBCC shrinkfile against the log files... On Thu, Dec 23, 2010 at 7:26 AM, <[email protected]> wrote: Greetings! I am not a DBA, nor have I ever played one on television. To aggravate things here, we are an IBM DB2 shop. So, I am not getting as much local help with this as I'd like (especially since the DBA's are taking extended weekends)... Our phone system has its records kept in an MS SQL 2005 database. It's been running for a bit over two years now. It has not been completely neglected as I have been doing manual backups of the phone database M-F. I am just now learning of other pieces, specifically transaction logs. I just now not only learned about them but ran a backup on them. The backup for the transaction logs is over 52 Gb(!). Obviously, this could very quickly run into storage and disk system issues. Although the backup for the transaction logs is set to append to the current, there is still that huge backup file (and I presume huge collection of transaction logs) which ought to receive some attention. I only know enough to 1) not simply go about deleting things, and 2) ask for help. HELP!!!! Thanks... -- Richard D. McClary Systems Administrator, Information Technology Group ASPCA® 1717 S. Philo Rd, Ste 36 Urbana, IL 61802 [email protected] P: 217-337-9761 C: 217-417-1182 F: 217-337-9761 www.aspca.org The information contained in this e-mail, and any attachments hereto, is from The American Society for the Prevention of Cruelty to Animals® (ASPCA®) and is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution, copying or use of the contents of this e-mail, and any attachments hereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify me by reply email and permanently delete the original and any copy of this e-mail and any printout thereof. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
