Forum Replies Created

Viewing 15 posts - 6,106 through 6,120 (of 6,395 total)

  • RE: Hi , How to check how many servers are there and information at a time in one command

    think what you are looking for is a central management server, will require all the "100" servers being registered under the CMS but you can execute a query against the...

  • RE: Best 3rd party management tools?

    take a look at the custom counters part of spotlight this is a powerful part of the app as it allows you to write your own metrics

    if your clued up...

  • RE: Best 3rd party management tools?

    This is a quote from Richard Jones @ Quest

    Hi Anthony, yes you do still get windows instances for free with SoSSE

  • RE: Best 3rd party management tools?

    Idera is more expensive than Quest

    Idera pricing per server for Diagnostic Manager for SQL (20% maintenance charge each year after)

    Lic & 1 Yr Maintenance - £1620

    Lic & 2 Yr Maintenance...

  • RE: How to Bring Online a Warm Standby Server

    you may want to look at renaming a SQL server as well (will try and find a link somewhere) as this is part of our recovery but may not be...

  • RE: Refresh of database

    to close existing connections you can set the database to single user which will close all connections to that db but leave the connection issuing the command in the db.

    alter...

  • RE: Refresh of database

    your best asking the person doing the handover what they mean by refresh, once you know it might be obvious, if not we are here to help

  • RE: Refresh of database

    can i ask why you would want to do that.

    surely that means that the database is not production as you would never want to go back to a point in...

  • RE: Refresh of database

    in terms of?

    what we call a refresh in our organisation is a copy of the live database, being placed onto the DEV/UAT/SYSTEST environment so that development have a like for...

  • RE: Restricting external/remote access

    by external / remote do you mean from outside of your organisation or nothing can use SQL apart from anything which runs on the SQL host?

    e.g block all WAN traffic...

  • RE: upgrade to 2008 reporting server

    i would do a side by side, new server, install 2008 SSRS, open up the reporting solutions in 2008 BIDS, convert to 2008, then redeploy.

    run 2005 and 2008 side by...

  • RE: Best 3rd party management tools?

    yeah the cost can be a bit daunting I do admit, but with Idera and Red-Gate (from what I know) their products only monitor SQL hosts, not any app servers,...

  • RE: Linked server from 64-bit SQL 2008 to Sybase

    yes I remember from the past that the Sybase ASA driver didnt like any type of cloning, the guys tried to be sneaky and create a ghost image with the...

  • RE: RC0 installation error

    yeah thats cool it has allowed to skip, but the VM name in as the Controller (unsure if that is right or if its just a namespace but it liked...

  • RE: Backup from shared hosting to another server

    i had the same issue the other week, our hosting provider would only restore a DB back to the DB server as a DB, they wont place the BAK file...

Viewing 15 posts - 6,106 through 6,120 (of 6,395 total)