Forum Replies Created

Viewing 15 posts - 23,656 through 23,670 (of 49,552 total)

  • RE: Db in recovery after restoring

    What happened before the restore is utterly irrelevant.

    If the restore was still running the state would be restoring, not recovering. Have a look through the SQL error log, starting with...

    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

    September 8, 2011 at 8:16 am

    #1378564

  • RE: Db in recovery after restoring

    After the restore?

    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

    September 8, 2011 at 8:02 am

    #1378549

  • RE: Db in recovery after restoring

    No. It'll be restoring until it finished rolling the insert back.

    Has the SQL instance restarted? Is the DB set to autoclose?

    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

    September 8, 2011 at 7:47 am

    #1378541

  • RE: Db in recovery after restoring

    What is the actual state of the database (status_desc in sys.databases)

    There's a major difference between RESTORING and RECOVERING

    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

    September 8, 2011 at 7:29 am

    #1378530

  • RE: Are the posted questions getting worse?

    All the sessions were recorded, they'll be up on the PASS website in a few weeks.

    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

    September 8, 2011 at 6:47 am

    #1378498

  • RE: Transaction log full by rebuilding index

    Ninja's_RGR'us (9/8/2011)

    GilaMonster (9/8/2011)

    Don't append log backups to a single file. It's hard to see what's there and damage to the file could result in losing all your backups.

    Where do you...

    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

    September 8, 2011 at 5:47 am

    #1378464

  • RE: 70-432 for 2008R2

    The exams are for 2008, not 2008 R2. There are no exams for 2008 R2.

    Number of questions varies, passing mark is 700/1000. Scoring for questions is not known

    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

    September 8, 2011 at 5:35 am

    #1378458

  • RE: Transaction log full by rebuilding index

    Don't append log backups to a single file. It's hard to see what's there and damage to the file could result in losing all your backups.

    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

    September 8, 2011 at 5:33 am

    #1378457

  • RE: Restore job skipping the logs on secondary server on SQL 2005!!

    Please post new questions in a new thread. Thank you.

    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

    September 8, 2011 at 5:32 am

    #1378455

  • RE: Transaction log full by rebuilding index

    Error 32: The process cannot access the file because it is being used by another process.

    My guess, the anti-virus exclusions aren't set correctly. Also write log backups to separate files,...

    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

    September 8, 2011 at 3:47 am

    #1378429

  • RE: SQL 2005 Max Memory Setting on Cluster

    ALZDBA (9/8/2011)

    SpringTownDBA (9/7/2011)

    short answer:

    DB1, min 6-7 GB, unlimited max

    DB2, min 3-4 GB, unlimited max

    as it is currently configured, you have 40 GB of ram and only 18 GB can...

    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

    September 8, 2011 at 2:35 am

    #1378406

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/7/2011)

    I'm going on at 2300GMT or 7:00PM EDT

    01h00 SAST. I'll try and be there.

    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

    September 7, 2011 at 1:15 pm

    #1378242

  • RE: Are the posted questions getting worse?

    SQLkiwi (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of the year?

    Talking of...

    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

    September 7, 2011 at 1:14 pm

    #1378239

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/7/2011)

    Grant Fritchey (9/7/2011)

    You all know Gail is on right now? She's doing great:

    https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H

    I'm going on at 2300GMT or 7:00PM EDT

    https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H

    You'll get close to 2 out of 7 hours...

    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

    September 7, 2011 at 1:13 pm

    #1378238

  • RE: Looking for page split operations in a non-recovered database txn log.

    Paul Duffett (9/7/2011)

    What if I had an unrecovered copy of the production database on a separte instance and "replayed" the transaction log backups, could I then query the transaction log...

    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

    September 7, 2011 at 10:41 am

    #1378127

Viewing 15 posts - 23,656 through 23,670 (of 49,552 total)