Browse by Tags

• Backup
• General
• Integration
• kba
• plan
• services
• SQL Server
• SQL Server 2008
• SQL Server Agent
• ssis
• SSMS
• Tools
• transaction log
• troubleshooting

• Do you perform log backup for the model database?

  Are you stupid, you might think... But stop and think for a while. Model is no different from other databases. And by default it is in full recovery model. So as soon as you do your first database backup (you do backup your system databases, right?) the...( Read More... Posted Wednesday, November 18, 2009 10:05 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, Backup, transaction log

• Do maintenance plans require SSIS?

  To many, this is a non-issue, since SSIS is installed anyhow. But not everyody installs SSIS. I for instance prefer to keep my production systems as clean as possible and only have what I really need (a principle which is harder and harder to live after...( Read More... Posted Wednesday, August 26, 2009 8:06 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, Backup, troubleshooting

• Watch out for that autogrow bug

  Under some circumstances, autogrow for database files can be set to some 12000 percent. I think this is limited to SQL Server 2005 and for databases upgraded from SQL Server 2000 (I didn't bother to search - feel free to comment if you know). So, if you...( Read More... Posted Wednesday, August 05, 2009 10:14 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, troubleshooting, SQL Server Agent

• sp_altermessage is back in business!

  Just a quick note that we again can modify whether system messages are to go to eventlog/errorlog again. I.e., we can change the is_event_logged column in sys.messages. This is very valuable in general and specifically is you want to define Agent alerts Read More... Posted Friday, May 15, 2009 6:36 AM from Tibor Karaszi | (Comments Off) Filed under: Tools, Maintenance, SQL Server 2008, SQL Server Agent

• Where's that sys.messages management pack?

  I've often been thinking that "somebody" should produce a list and perhaps some ready-made TSQL code of the SQL Server error messages we want to be alerted for. Something like a Management Pack, but not tied to any particular sys mgmt software. Essentially, Read More... Posted Tuesday, February 24, 2009 5:37 AM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, troubleshooting

• Updates of Ola Hallengren's maint procedures

  Ola Hallengren has updated his maint procedures. Support for SQL Server 2008 and some bug fixes. Check them out at: http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html Share this post: email it! | bookmark it! | digg it! | reddit! | kick Read More... Posted Saturday, August 23, 2008 5:49 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance

• More maint procedures

  A few months ago, I blogged about a simple procedure to do backup ( http://sqlblog.com/blogs/tibor_karaszi/archive/2007/09/25/tsql-script-to-do-backup-like-maintenance-plans.aspx ). Just to let you know that Ola Hallengren has some of his own. Much more Read More... Posted Friday, January 11, 2008 7:57 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, Backup

• TSQL script to do backup like Maintenance Plans

  This is frequently asked question, both in forums, as well as in class: How can I though TSQL create new backup files for each backup and have date and time in the file names? The reason for above is most often that you want a higher degree of customization Read More... Posted Wednesday, September 26, 2007 2:20 AM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, Backup

• On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications Read More... Posted Friday, August 24, 2007 6:15 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Maintenance, Integration, SSMS, services, ssis, kba, plan

• Is statistics over non-indexed columns updated by index rebuild?

  Short answer: no . This question came up today in the MCT discussion group. My gut instinct said no, but I wanted to test it to be certain. But first a brief background: You can rebuild an index using DBCC DBREINDEX or in 2005 (and now preferred) ALTER Read More... Posted Friday, August 10, 2007 2:18 AM from Tibor Karaszi | (Comments Off) Filed under: General, Maintenance

• Be aware: Sp2, maint plans and CHECKDB

  Tony Rogerson brought to my attention that with sp2, a plan that does CHECKDB seems to always do it against the master database. Technicalities seems to be in how SSIS executes SQL commands, separates batches and connection pooling (sp_reset_connection). Read More... Posted Thursday, March 08, 2007 7:44 PM from Tibor Karaszi | (Comments Off) Filed under: Tools, Maintenance

• Leaking roof and file shrinking

  Shrinking and growing database files cost you resources and have other side effects as well. I have a technical description http://www.karaszi.com/SQLServer/info_dont_shrink.asp if you want to get into details about it. Sure, you can have valid reasons Read More... Posted Sunday, February 25, 2007 8:31 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance

• Review your Maint Plans after sp2!

  You might have heard that Maint Plans has had some work on them in sp2. One enhancement is that the Maintenance Cleanup Task now allow for removing of backup files based on hours. This can lead to undesired too early cleanup if you upgraded such a plan. Read More... Posted Sunday, February 25, 2007 8:03 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance