Forum Replies Created

Viewing 15 posts - 34,036 through 34,050 (of 49,552 total)

  • RE: Administration

    I would think that's a question better asked in a forum related to Remedy. As for an URL, start with http://www.google.com/

    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

    February 13, 2010 at 9:34 am

    #1118451

  • RE: Trnasaction log

    Please read through this - Managing Transaction Logs[/url]

    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

    February 13, 2010 at 9:31 am

    #1118449

  • RE: SQL Server

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic865102-24-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

    February 13, 2010 at 9:31 am

    #1118448

  • RE: Backup

    Have a read through Books Online, specifically the BACKUP DATABASE page.

    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

    February 13, 2010 at 9:31 am

    #1118447

  • RE: Maintanence plan

    Without the full error message, no way to tell.

    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

    February 13, 2010 at 9:30 am

    #1118446

  • RE: Administration

    Please don't post in all caps. It's the online equivalent of shouting at people.

    Have you checked Books Online?

    In this case you can query sysprocesses

    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

    February 13, 2010 at 9:30 am

    #1118445

  • RE: Differential Backup

    ashish.kuriyal (2/13/2010)

    What is important is your log backup must be at regular frequency as per your database size

    Frequency of log backups is not related to DB size. It's related to...

    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

    February 13, 2010 at 9:28 am

    #1118444

  • RE: dbcc checkdb Error

    SQLBOT (2/13/2010)

    Try running dbcc checkdb with REPAIR_REBUILD

    That will fix corruption only when the minimum repair level specified by CheckDB is REPAIR_REBUILD. That will occur when corruption is in nonclustered indexes...

    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

    February 13, 2010 at 9:25 am

    #1118443

  • RE: dbcc checkdb Error

    You've got damage to the system tables there. That is not repairable in any way. Get out your latest backup and restore.

    If the DB is in full recovery, take a...

    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

    February 13, 2010 at 9:17 am

    #1118442

  • RE: Are the posted questions getting worse?

    Bru Medishetty (2/12/2010)

    GilaMonster (2/12/2010)

    Google's english to afrikaans translator's not that great either apparently...

    Lalani kahle abantu bonke.

    A e be boroko lena bohle.

    Rhonantini.

    Now I don't find Zulu translator, all I know about...

    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

    February 12, 2010 at 9:53 pm

    #1118391

  • RE: Are the posted questions getting worse?

    Google's english to afrikaans translator's not that great either apparently...

    Lalani kahle abantu bonke.

    A e be boroko lena bohle.

    Rhonantini.

    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

    February 12, 2010 at 2:02 pm

    #1118297

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/12/2010)

    Ok - Thread commandeered. Should we go all french all the time?

    Jy kan, maar ek nie Frans praat nie. Miskien sal ek Arikaans of isiZulu praat.

    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

    February 12, 2010 at 1:10 pm

    #1118268

  • RE: Data disappearing from tables mysteriously

    mwstewart (2/12/2010)

    so you're saying that timeout issues will cause rollbacks?

    If the application timeout is exceeded, the application will tell SQL to stop processing that query (same as if...

    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

    February 12, 2010 at 1:01 pm

    #1118259

  • RE: Unable to update Query Processor Statistics

    Does DBCC CheckCatalog come back without errors?

    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

    February 12, 2010 at 12:34 pm

    #1118231

  • RE: Data disappearing from tables mysteriously

    mwstewart (2/12/2010)

    The customer had HP take a look at their SAN and they say everything looks normal. Based on the time of day this has been occurring, I'm thinking...

    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

    February 12, 2010 at 12:25 pm

    #1118226

Viewing 15 posts - 34,036 through 34,050 (of 49,552 total)