Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 9,244 total)

  • RE: SQL Cluster - Multi Instance

    hindle.steve (3/20/2012)

    I have a SQL 2008 R2 Cluster name of say SQLCluster1 on NodeA with an instance name of Instance1 ie. SQLCluster1\Instance1. I also want to install another instance called...

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

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

    March 20, 2012 at 8:47 am

    #1461678

  • RE: Can we set up separate network card for Backups and Log shipping?

    The backup drive is a local SAN presented drive

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

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

    March 19, 2012 at 11:15 am

    #1461270

  • RE: Problem patching to 2008 SP3

    Kenneth.Fisher (3/19/2012)

    Perry Whittle (3/19/2012)

    how long have you left it for, what do you see in task manager?

    I've left it for several minutes but didn't notice anything in task manager.

    At this...

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

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

    March 19, 2012 at 11:09 am

    #1461266

  • RE: Can we set up separate network card for Backups and Log shipping?

    gmamata7 (3/19/2012)

    the backup drive is Clustered Shared drive sitting on SAN. So in that case, we do not need any separate NIC as the backup directly writing to disk on...

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

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

    March 19, 2012 at 11:05 am

    #1461263

  • RE: Can't configure log shipping

    To use log shipping in SQL Server 2000 did indeed require Enterprise edition, but that's not the issue here.

    Del Lee (3/19/2012)

    Any more suggestions on this? I am now seeing...

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

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

    March 19, 2012 at 10:10 am

    #1461216

  • RE: Problem patching to 2008 SP3

    how long have you left it for, what do you see in task manager?

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

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

    March 19, 2012 at 10:01 am

    #1461208

  • RE: SQL Architecture Consolidation

    rabensql (3/8/2012)

    Dear all,

    I'm planning implementation of a new SQL infrastructure for my customer in the project department. Currently, I have really few information’s, which will come later from production department....

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

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

    March 19, 2012 at 9:39 am

    #1461192

  • RE: How to rename the physical Nodes servernames in a Cluster?

    DBA in Unit 7 (3/14/2012)

    Thanks a lot for the pointer, Gianluca. That is quite helpful.

    Looks like there is more to it.

    I may reconsider if this is worth to doing...

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

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

    March 19, 2012 at 9:35 am

    #1461191

  • RE: Unable to shrink an almost empty ndf file

    sbaker-757360 (3/19/2012)

    Thank you Perry for the script.

    You're welcome

    sbaker-757360 (3/19/2012)

    But when I recreated the other 5 indexes, I failed to edit to the new filegroup.

    So I have 46.2GB of index...

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

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

    March 19, 2012 at 9:28 am

    #1461189

  • RE: MSCS Server and VmWare

    rabensql (3/19/2012)

    Thank you Perry Whittle.

    I want MSCS for server maintenance (reboot, service pack, updates) and also for software failure. Other solution should be mirroring with automatic failover, but it's not...

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

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

    March 19, 2012 at 5:57 am

    #1461075

  • RE: How to find out what is actually in use

    drew.georgopulos (3/18/2012)

    The idea instigated a riot among the developers because of the fear factor; no one knows what actually IS in use, so their intention is to move everything to...

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

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

    March 18, 2012 at 10:41 am

    #1460936

  • RE: Backup Job failed due to enough disk space

    Can you post a screenshot of the plan

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

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

    March 18, 2012 at 3:01 am

    #1460918

  • RE: Benefits of having Mirroring and Clustering in the same place

    What is the design intended to provide?

    Do you require purely a fail over scenario for redundancy or replicated copies of the database for reporting offload, etc.

    Clustering generally has a higher...

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

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

    March 17, 2012 at 4:40 pm

    #1460908

  • RE: Release unused space after drop table in SQL 2008 Enterprise Edition

    AER (3/17/2012)

    Did you create a new post?

    Yes, here[/url]

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

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

    March 17, 2012 at 3:20 pm

    #1460904

  • RE: SQL Failover Cluster WMI

    There's a few issues there really. The first error complains about bluster disk 4 failing. The second complains about the Dns registration for the network name.

    Check the TCP\IP settings on...

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

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

    March 17, 2012 at 1:36 pm

    #1460894

Viewing 15 posts - 5,821 through 5,835 (of 9,244 total)