Post reply

SQLServer Error: 824

  • February 28, 2010 at 10:09 am

    #1126280

    Don't do that. I strongly advise you to call Product Support who will stay with you on the phone while you sort this out - no disrespect, but with the level of SQL knowledge you're displaying, you need more intimate help with this than we can provide over Internet forums.

    Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • February 28, 2010 at 10:10 am

    #1126281

    That's a little extreme, don't you think?

    There are documented ways (and scripts) to rebuild msdb. eg here - http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx

    Sure, a reinstall will fix it, but you'll have wasted all the time of the reinstall, plus reattaching all your user databases, plus recreating all your logins and server permissions, plus the time to recreate the backups, jobs, packages, etc

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply