Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 9,241 total)

  • RE: SP upgrade for SQL 2005 active/passive cluster

    SQL!$@w$0ME (2/7/2014)


    Does it mean we run SP installer from active node?

    Yes

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: cannot log into server in single user mode

    Something else has grabbed the single connection, an application srevice most likely. Do the following

    • terminate the single user mode startup
    • edit the startup parameters to use -m"SQLCMD"
    • start the sql instance in...

      -----------------------------------------------------------------------------------------------------------

      "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DNS entry for SSRS

    sql_dba123 (2/7/2014)


    But since SSRS 2008 and above don't require IIS, you may have to install IIS in the SSRS server

    SSRS still uses the same drivers that IIS uses, HTTP.sys...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Encryption

    DuncEduardo (2/7/2014)


    Thanks Perry - I'm personally trying to push for this approach.

    Net Admin initially said that these methods can be resource-heavy and the preference is Tokenisation. However, having examined the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: OS Disk Capacity Information

    Lowell (2/5/2014)


    would you consider adding a CLR procedure that gets the data instead? that seems like a much better way to go.

    http://www.mssqltips.com/sqlservertip/1986/sqlclr-function-to-return-free-space-for-all-drives-on-a-server/

    That only gets the drive level info and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: OS Disk Capacity Information

    a simple WMI query via WMIC can get this info and can be run via the agent

    wmic volume get blocksize, capacity, "free space", name

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How do I find out server name and instance name? Thanks

    halifaxdal (2/5/2014)


    I just upgraded from SQL 2008 R2 to SQL 2012 and also installed Data Tools.

    I tried to use it but the first thing is, off course, prompt me to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How do I find out server name and instance name? Thanks

    halifaxdal (2/5/2014)


    Maddave (2/5/2014)


    The MSSQLSERVER in the service name shows it is a default instance, so you should just be able to put in the hostname of the server.

    Unfortunately still not...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Encryption

    DuncEduardo (1/30/2014)


    so how would you ensure PCI Compliance by protecting the clear text information being passed to server from application?

    Secure and encrypt channels between the client and server. IPSec, when...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SP upgrade for SQL 2005 active/passive cluster

    SQLisAwE5OmE (2/4/2014)


    Can you share your experience for SP upgrade for SQL 2005 active/passive cluster.

    I have read that for sql 2005 you do the upgrade to the active node first and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2008 R2 transaction log shipping

    Read this[/url], it may help in the future

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Restart mirroring for a log shipping environment after DR test

    consult this article first

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Failed install - 2008 Standard

    go into add\remove programs and uninstall the sql native client then re run the installer

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Failover cluster and global groups

    N.D (2/4/2014)


    ah cheers, so it's the OS that's the dependency & that answers my question very nicely 🙂

    On Windows 2008 you'll still get the option of AD groups but you...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Convert Drive Letters to Mount Points in SQL Cluster

    Moving the user and system database files to different locations can be done. It depends on your amount of experience with SQL Server. The fact that the mounted volumes are...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Viewing 15 posts - 3,586 through 3,600 (of 9,241 total)