Forum Replies Created

Viewing 15 posts - 33,886 through 33,900 (of 49,552 total)

  • RE: Emergency!!!!!!!! Production Databases

    dennisengel (2/18/2010)

    Step 1: I had restored these databases to another server from backups, and kept business going. I has good full backup and t- logs backups, fortunately I had...

    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 19, 2010 at 1:17 am

    #1121607

  • RE: How to modify 'system stored procedure' SQL 2008?

    Leon Orlov-255445 (2/18/2010)

    Sys proc sp_addrolemember... called directly from the add new user event when you click check box next to any system roles beside 'public. Well, the question 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

    February 19, 2010 at 1:03 am

    #1121597

  • RE: Emergency!!!!!!!! Production Databases

    GT-897544 (2/18/2010)

    GilaMonster (2/18/2010)

    GT-897544 (2/18/2010)

    If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.

    It's not.

    Cleanly shutdown is indicated by value...

    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 18, 2010 at 3:35 pm

    #1121445

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/18/2010)

    No kidding. That's more than my house payment.

    It's about 5 times my house payment.

    To give you a rough idea, I pay around R500/month for 512kb/s with 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 18, 2010 at 3:25 pm

    #1121436

  • RE: Are the posted questions getting worse?

    jcrawf02 (2/18/2010)

    So what you're saying is we should invest in SA telco?

    It's mostly government owned.

    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 18, 2010 at 3:15 pm

    #1121431

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/18/2010)

    Is that per month??

    Yes, both the price and the download limit. Have edited to make that clearer.

    In case it's not obvious, that's not aimed at the individual user....

    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 18, 2010 at 3:11 pm

    #1121426

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/18/2010)

    GilaMonster (2/18/2010)

    CirquedeSQLeil (2/18/2010)

    Already started the packages - should I send them by swallow to Gail?

    Pigeon or smoke signal please. Swallows exceed the internet speed limit in this part...

    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 18, 2010 at 3:06 pm

    #1121418

  • RE: Emergency!!!!!!!! Production Databases

    GT-897544 (2/18/2010)

    If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.

    It's not.

    Cleanly shutdown is indicated by value 1073741824 in...

    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 18, 2010 at 2:54 pm

    #1121407

  • RE: Emergency!!!!!!!! Production Databases

    GT-897544 (2/18/2010)

    Alvin Ramard (2/18/2010)

    GT-897544 (2/18/2010)

    Lynn Pettis (2/18/2010)

    GilaMonster (2/18/2010)

    GT-897544 (2/18/2010)

    2) If so go head and bring one database offline and then bring online that should work, if database come online clean,...

    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 18, 2010 at 2:51 pm

    #1121404

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/18/2010)

    Already started the packages - should I send them by swallow to Gail?

    Pigeon or smoke signal please. Swallows exceed the internet speed limit in this part of the world.

    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 18, 2010 at 2:49 pm

    #1121399

  • RE: Negative number in sp_spaceused unallocated_space

    n.heyen (2/18/2010)

    I normally wouldn't shrink a database but I get nasty-grams from the server admins about the disk being full.

    Tell then that the database is full and very soon...

    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 18, 2010 at 2:35 pm

    #1121376

  • RE: Emergency!!!!!!!! Production Databases

    Dennis

    Still need to see the exact error that you get when you try, from management studio, to query one of the databases.

    Still need to see any and all errors in...

    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 18, 2010 at 2:30 pm

    #1121371

  • RE: Emergency!!!!!!!! Production Databases

    GT-897544 (2/18/2010)

    GilaMonster (2/18/2010)

    GT-897544 (2/18/2010)

    2) If so go head and bring one database offline and then bring online that should work, if database come online clean, recycle SQL services, should...

    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 18, 2010 at 2:28 pm

    #1121369

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/18/2010)

    Should we be working on the SSIS packages now to extract the data from the databases? 😛

    No, no, no. You obviously didn't notice the side mention in...

    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 18, 2010 at 2:25 pm

    #1121362

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (2/18/2010)

    Surely it does have to cease being an emergency after 24hrs.

    There have been shorter wars.

    http://www.sqlservercentral.com/Forums/Topic867521-1550-1.aspx

    Oh boy, here we go again....

    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 18, 2010 at 2:22 pm

    #1121357

Viewing 15 posts - 33,886 through 33,900 (of 49,552 total)