SQL 2005 Enterprise Maintenance

• webrunner

  SSC-Dedicated

  Points: 31938

  More actions

  March 4, 2008 at 3:07 pm

  #120257

  Hello,

  I saw this statement in a Microsoft page describing SQL Server 2005 editions:

  SQL Server 2005 Enterprise Edition Benefits

  "Zero downtime during maintenance operations."

  Zero downtime during maintenance operations sounds great, but I'm not sure what this statement means. Does anyone know?

  Thanks for any help,

  webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Ash73

  SSC Veteran

  Points: 286

  More actions

  March 4, 2008 at 3:41 pm

  #785240

  Believe it refers to maintenance actions such as moving a table online, partitioning a table online, accessing a database that's partially damaged, performing online piecemeal restore, etc. Got that from here...

  http://www.sqlskills.com/blogs/kimberly/CategoryView,category,SQL%2BServer%2B2005.aspx