Forum Replies Created

Viewing 15 posts - 3,226 through 3,240 (of 9,244 total)

  • RE: best practice for remote connecing to SQL Server Express?

    Eric Mamet (6/23/2014)


    Ah..... :unsure:

    Set the static port on the IPALL section and not for an individual address

    I only set it for a specific IP address.

    Do I leave the...

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

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

  • RE: Connecting to Clustered Instance

    what version of VCS are you using?

    have you contacted symantec or checked their knowledgebase for help?

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

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

  • RE: best practice for remote connecing to SQL Server Express?

    Eric Mamet (6/22/2014)


    I have installed a SQL Server 2012 Express on a Windows 2008R2 and am struggling to connect remotely to my database.

    There is no other database server on...

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

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

  • RE: best practice for remote connecing to SQL Server Express?

    edit

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

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

  • RE: urgent please help DBAs- NDF files and transaction log files

    rquest7 (6/22/2014)


    While we were trying to purge the data in our SQL Standard database files ,the rows are not getting dropped or deleted from the NDF files and the transaction...

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

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

  • RE: urgent please help DBAs- NDF files and transaction log files

    GilaMonster (6/23/2014)


    rquest7 (6/22/2014)


    What are the steps that a DBA or sql admin needs to do, to resolve the transaction log full issue

    Did you bother to read the article I...

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

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

  • RE: Copy whole instance to different server.

    WolfgangE (6/22/2014)


    For moving the system databases - they inlcude logins, jobs and that stuff - have a look at books online how to do it. You need master, msdb and...

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

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

  • RE: Server Role Membership Validation

    i use the following

    SELECT sp.name AS ServerPrincipal,

    sp.type_desc AS LoginType,

    CASE sp.is_disabled

    WHEN 0 THEN 'No'

    WHEN 1 THEN 'Yes'

    END AS UserDisabled,

    sp.create_date AS DateCreated,

    sp.modify_date AS DateModified,

    sp.default_database_name AS DefaultDB,

    sp.default_language_name AS DefaultLang,

    sp2.name...

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

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

  • RE: Patching Clustered Instances

    SQLSvrStevo (6/13/2014)


    We did apply this in our test environment some weeks ago but no one took note of how long the script update state

    Check the sql server log there may...

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

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

  • RE: Standalone to Cluster

    ntrovato (6/10/2014)


    I will be using Steeleye Datakeeper to do the clustering of SQL 2008 ... it does not require shared storage. See below.

    http://clusteringformeremortals.com/2009/09/15/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-1/

    It's replicated storage which although not strictly shared...

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

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

  • RE: Not able to create the db and restore the db in cluster environment

    Shawn Melton (6/12/2014)


    If the quorum drives show offline on server1, then this is no longer the active node, it is server2.

    It doesnt matter where the quorum drive is online,...

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

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

  • RE: Patching Clustered Instances

    It will take as long as it needs, have you thought of performing this first in a test\QA env to see what the results are?

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

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

  • RE: Restoring master database

    post screenshot of the following registry location

    HKEY_LOCAL_MACHINE\SOFWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.R8\MSSQLServer\Parameters

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

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

  • RE: Restoring master database

    Ratheesh.K.Nair (5/30/2014)


    Perry Whittle (5/30/2014)


    Ratheesh.K.Nair (5/30/2014)


    I have given everyone full access to the location but still gets the same error.

    If inheritance is turned off you could see this issue. Open...

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

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

  • RE: Restoring master database

    Ratheesh.K.Nair (5/30/2014)


    I have given everyone full access to the location but still gets the same error.

    If inheritance is turned off you could see this issue. Open the security properties...

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

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

Viewing 15 posts - 3,226 through 3,240 (of 9,244 total)