Forum Replies Created

Viewing 15 posts - 7,516 through 7,530 (of 9,241 total)

  • RE: Geographically dispersed multi-site "multi-instance" with SQL 2008 R2

    david.armstrong 13072 (10/18/2010)


    It seems like transactional replication would get the job done.

    providing all the replication objects have a primary key defined!

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

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

  • RE: cluster Failover

    mushtaq777 (10/19/2010)


    Cluster node 'XYZ' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having...

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

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

  • RE: Another MSDTC question

    the only dependencies required for the MSDTC should already be in place. MSTDC depends upon its disk and network name resource! Yes, you will need admin privileges to create the...

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

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

  • RE: SQL Server 2008 MS DTC

    The document is 4MB in size so you need to be patient. Right click the link and select "Save target as...", then open the PDF once downloaded!

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

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

  • RE: How to create new instance in sql server 2005

    what info is there in the Windows event logs?

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

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

  • RE: SQL Server 2008 MS DTC

    To add to what Halcyon has already stated

    Duran (10/19/2010)


    I did try to slipstream the install, but I got an SQL Native Bootrapper stopped working error, so I tried another slipstream...

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

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

  • RE: How to create new instance in sql server 2005

    Are all the services started without error?

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

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

  • RE: DB Engine service won't start with service account

    Incidentally, rathing than poking around manually setting SPN's just allow the service account to do it automatically.

    In ADSIEDIT find you service and account and select properties then go to the...

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

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

  • RE: Error while moving model and msdb system databases.

    You may want to bookmark the following link for future reference

    http://msdn.microsoft.com/en-us/library/ms345408.aspx

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

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

  • RE: DB Engine service won't start with service account

    turfnsurf4me (10/19/2010)


    What I neglected to articulate is that I use the ADSI Edit snap-in and edit the service principal name property ( of the service account) directly while on the...

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

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

  • RE: SQL server instance ip's

    gaganks (10/19/2010)


    Thanks Perry, But is there a T-SQL statement to know this incase a user doesn't have RDT access.

    Thank you.

    Not as I remember, the entry point into the clustered instance...

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

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

  • RE: SQL server instance ip's

    Clustering has changed a lot between the 2 platforms. On the Cluster node go into cluster administrator and select the resource group for the instance you wish to view details....

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

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

  • RE: Process to install SQL Server 2005 on a newly build passive node

    Ok, as far as I remember SP3 does not have the single node install issue that affects SP2!

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

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

  • RE: Recovering OS file space

    OK, it's important to know this to keep a handle on the growth!

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

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

  • RE: Process to install SQL Server 2005 on a newly build passive node

    on the active node go into add\remove programs. Select SQL Server 2005 and click the change button. Set up will launch, select the clustered instance you wish to install the...

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

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

Viewing 15 posts - 7,516 through 7,530 (of 9,241 total)