Forum Replies Created

Viewing 15 posts - 151 through 165 (of 474 total)

  • RE: wmi_mssql_transactionpersec is critical

    ramuboddepalli (4/6/2010)


    we were using the naigos tool for monitoring the performance of our server and the bounds for the total transactions per sec is set with the treshold 200-warning and...

  • RE: SQL 2008 Compressed Backups

    Lynn Pettis (4/2/2010)


    You may want to use compression on your t-logs as well. I am doing it on all three to great success.

    Yea, I thought about that. But...

  • RE: SQL 2008 Compressed Backups

    Yea, you never know when you are going to pick up a useful nugget of information in the least likely place in the threads.

    Personally, I think it's worth joining sqlservercentral.com...

  • RE: SQL 2008 Compressed Backups

    Thanks for the input (this turned into a neat discussion!).

    I just switched everything over to use backup compression for my full and differential backups, and it seems to be chugging...

  • RE: SQL 2008 Compressed Backups

    Alright...I'll give it a shot.

    I'm just doing simple backups now, and then zipping them. The speed of native compression is really impressive compared to my current process....

  • RE: Rebuild and Reorganize Indexes

    MTY-1082557 (3/29/2010)


    I do it in order to rebuild or reorganize an index that is block during the process.

    is that wrong to do?

    Hard to say if it's "wrong" based on what...

  • RE: Where are you?

    Kansas City, KS

  • RE: Where are you?

    Lynn Pettis (3/23/2010)


    John Rowan (3/23/2010)


    It's in Keystone, SD. The nearest 'big' town is Rapid City, SD, which is about 1/2 hour away. I was born just outside of...

  • RE: Restore Database with a new name

    MTY-1082557 (3/25/2010)


    Hi all,

    I have a database called DB and I need to restore it on the same Box with different name. Can anybody tell me if this instruction is...

  • RE: Cannot generate SSPI Context

    The name change is probably your issue as Wayne said (or at least it's one issue you need to deal with if you haven't already).

    If it doesn't match when you...

  • RE: Standard Edition or Enterprise Edition?

    GSquared (3/19/2010)


    Jason Shadonix (3/19/2010)


    Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard...

  • RE: Standard Edition or Enterprise Edition?

    Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard edition?

  • RE: Does a Job failed result in change in permissions for a Table?

    So you're in a development position and not in a DBA position? If that's the case, I (personally) wouldn't be spending much time figuring it out and make the...

  • RE: Backups

    And then you're also moving those backups you make onto the SAN to tape or some external/offsite place, right?

Viewing 15 posts - 151 through 165 (of 474 total)