Forum Replies Created

Viewing 15 posts - 24,421 through 24,435 (of 49,552 total)

  • RE: Database--Suspect mode question

    GilaMonster (8/4/2011)

    It's caused when SQL either fails to complete a transaction rollback due to corruption or when it start but can't complete crash recovery, usually due to the same.

    Fix is...

    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

    August 5, 2011 at 5:02 am

    #1364226

  • RE: Database--Suspect mode question

    No, No, No, No, No!!!!!!!!!!!!!!!!!!!!

    Emergency mode repair is the VERY LAST RESORT. It's done when NOTHING else works, NOTHING else can be done and there are NO other options. It...

    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

    August 5, 2011 at 4:53 am

    #1364219

  • RE: Is it required to change the initial DB size ??

    10MB is still not a sensible size. The database is 20GB in size. If it needs to grow by 200MB (not a large amount) you want it to do that...

    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

    August 5, 2011 at 4:50 am

    #1364218

  • RE: LOG AUTOGROWTH

    Fixed value. The problem with % is that the growth increment increases as the file grows. It means that the time taken increases as well, and that can have impact...

    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

    August 5, 2011 at 4:13 am

    #1364209

  • RE: Is it required to change the initial DB size ??

    That autogrow needs changing among other things. Grow the DB to maybe 25GB (if it's 20 and full, it needs to grow), then change the autogrow to something sensible like...

    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

    August 5, 2011 at 3:46 am

    #1364198

  • RE: Is it required to change the initial DB size ??

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1154866-146-1.aspx

    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

    August 5, 2011 at 3:46 am

    #1364196

  • RE: How to manage subscription DB log growth?

    Mr. Holio (8/5/2011)

    edited:

    And what about the publication dbs?? thank you.

    Same thing, if the recovery model is full, you must have log backups or the log files will grow until they...

    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

    August 5, 2011 at 3:44 am

    #1364194

  • RE: How to manage subscription DB log growth?

    Mr. Holio (8/2/2011)

    I use transactional replication and my subscription database log file is growing (now it is 50GB) and cannot be shrunk because replication is occuring.

    It can't be shrunk...

    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

    August 5, 2011 at 3:25 am

    #1364179

  • RE: How to Sync SS 2008 R2 Production database with different versions of SQL server (2005, 2008)

    For 2008, same thing. Replication or manual. It will work providing you use no features that aren't supported on the lower version.

    For 2008 R2 to 2008 R2, depends on your...

    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

    August 5, 2011 at 3:22 am

    #1364177

  • RE: Can REBUILDING the index cause deadlock?

    How big's the index?

    For deadlocks, you should fix the root cause, not worry about whether an index rebuild changed things so that the deadlock happened. Switch traceflag 1222 on. That...

    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

    August 5, 2011 at 3:20 am

    #1364175

  • RE: Using SQL Server 2005 for 2008 exams

    You could if you really wanted to but since it would give you no practice on the new features and the exams do extensively cover the new features you may...

    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

    August 5, 2011 at 3:13 am

    #1364171

  • RE: T-SQL Unique index act as Fuzzy Lookup

    The Dixie Flatline (8/4/2011)

    Just thinking out loud here. If he could come up with some sort of formula to condense the name strings down... by omitting vowels...

    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

    August 5, 2011 at 3:08 am

    #1364164

  • RE: CHECKDB Error

    Ratheesh.K.Nair (8/4/2011)

    Thanks a lot Gail.

    Is there anyway I can save the data?

    Take a tail-log backup, restore from a clean backup. Restore the log backups from after that full backup right...

    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

    August 5, 2011 at 3:08 am

    #1364162

  • RE: SQL Services restarted?

    SQL ORACLE (8/4/2011)

    GilaMonster (8/4/2011)

    If it's the active node you're rebooting, yes.

    If so, any running job will be killed?

    All connections will be dropped, all open transactions roll back. Once the SQL...

    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

    August 5, 2011 at 2:58 am

    #1364157

  • RE: SQL Services restarted?

    duda (8/5/2011)

    Couldn't agree with you more about @SQLFRNDZ's comment, and why would you want to [start\stop] SQL services within a cluster using windows services?

    From what I understand if you do([start\stop]...

    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

    August 5, 2011 at 2:56 am

    #1364155

Viewing 15 posts - 24,421 through 24,435 (of 49,552 total)