Forum Replies Created

Viewing 15 posts - 16 through 30 (of 43 total)

  • RE: When Will You Upgrade to SQL Server 2012?

    I think for a lot of DBAs it's a comfort thing as well.

    I know I have all my tools set up the way I like them, all my alerts fire...

  • RE: Automating Daily Checks with Powershell

    Cheers for this.. I'll be working on this over the next few days..this will be a great help

  • RE: Automating Daily Checks with Powershell

    Excellent, many thanks.

  • RE: Automating Daily Checks with Powershell

    HooO! any chance of a copy of your script? We're on 2005, so no sql built-ins are available for our PowerShell.

    Does your script work on 2005 ?

  • RE: Automating Daily Checks with Powershell

    No, the <<< is inserted by the PowerShell parser to show where the error is in the line.

    Personally, I think that just stating line number is enough to find an...

  • RE: Automating Daily Checks with Powershell

    Ahh, never mind. We're on SQL 2005 so this won't work anyway.

    Back to roll-my-own, then...

  • RE: Automating Daily Checks with Powershell

    I've set this up as I'm looking to create a full-on daily server checks checks myself, so this was very timely.

    I'm getting an error though:

    You must provide a value expression...

  • RE: Does It Help

    Definitely 2 monitors.

    I often have to review scripts - sometimes many, many scripts. Being able to have a file manager one one screen and SSMS on the other is a...

  • RE: The Low End

    I've always considered Acces and VB, macros and so forth as very good tools for prototyping.. getting something that both looks and works the way the customer wants very quickly.

    I...

  • RE: Reset SQL user password by user it self if they forget.

    Ahh.. cross domain? I have somewhat the same problem since our production servers are not on the same domain as the dev environment and the staging server is on yet...

  • RE: Reset SQL user password by user it self if they forget.

    Assuming you're on a Windows environment, why not use Windows usernames and passwords?

    On our DEV, TEST, Staging and UAT boxes, only applications use SQL user accounts, not people.

    I get...

  • RE: Microsoft Recommends

    Adiga (8/4/2010)


    Increasing the timeout value from 10 to 30 will ensure that the mirror monitor will ry for 30 seconds before throwing the time out error.

    Yes, I understand that part,...

  • RE: What do you make of this

    I was being a bit facetious...

    Yes, it looks to me like a jabbering net card or a faulty cable.

    Our hosting provide insists we have a 1Gbit uplink on the mirror....

  • RE: Mirroring

    Well, I'll need to get hold of the original contracts, but I'm thinking that they never specified a private link of any sort.

    As with all inherited systems, I'm finding it...

  • RE: Mirroring

    I'm trying to get hold of SLA's and so forth, and yes the ISP is responsive - their suggestion was we go to log Shipping instead of mirroring.

Viewing 15 posts - 16 through 30 (of 43 total)