Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 9,244 total)

  • RE: SQL Server 2012 Clustering Questions

    you're welcome 😎

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

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

  • RE: Read and Write speeds not increased with additional disks.

    william.rees.howells (3/13/2014)


    Does anybody know why I see absolutely no performance improvement when I spread my primary file group over 8 separate files on 8 separate disks, as opposed to...

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

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

  • RE: Migration of large database to multiple files, DBCC EMPTYFILE and blocking

    Adam Bean (3/13/2014)


    You can indeed perform an EMPTYFILE on the primary file; however it will end in error as you can't move the system objects, yet it does move the...

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

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

  • RE: SQL 2008 support on Windows 2012

    😉

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

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

  • RE: SQL 2008 support on Windows 2012

    Software requirements for SQL Server 2005 which doesn't mention Windows 2012 and has listed dependencies to run it on Windows 2008

    http://msdn.microsoft.com/en-us/library/ms143506(v=sql.90).aspx

    Based on that i would say SQL server 2000 a...

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

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

  • RE: Migration of large database to multiple files, DBCC EMPTYFILE and blocking

    Adam Bean (3/11/2014)


    Hey all,

    Here's my scenario. We have a 1.2TB database that we are now going to break up into multiple files. Unfortunately the vendor of this database does not...

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

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

  • RE: Prevent automatc startup of SQL server on Cluster after windows reboot

    SQL!$@w$0ME (3/12/2014)


    Guys,

    I need to disable automatic startup of SQL Server on a 2 node active/passive cluster after Windows reboot.

    What is the best way to follow?

    If you take the SQL...

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

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

  • RE: SQL Clustering Best Practice

    paul-1007285 (3/13/2014)


    Hi,

    I have a rather simple, one would think, question.

    Clustering sql, we have a active active node setup, whats the best way....

    ClusterNode1\Instance1

    ClusterNode2\Instance2

    ???

    Then whats the best practice...

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

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

  • RE: AG Failover Order

    You can have more than 2 synch replicas but only 2 for auto failover

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

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

  • RE: AG Failover Order

    PHXHoward (3/12/2014)


    I had hoped to have a failover order for AGs using preferred nodes similar to how FCIs work.

    That is not how FCIs work, they cycle through the possible...

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

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

  • RE: Upgrade using db mirroring

    Oracle_91 (3/12/2014)


    Hi Everyone,

    I came to know that using SQL Server database mirroring, we can perform the upgrades with minimal downtime.

    How that is possible? Can anyone elaborate ?

    I...

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

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

  • RE: AG Failover Order

    PHXHoward (3/11/2014)


    We hoped to have a failover priority order. Three synchronous replicas. One secondary locally and one in the other datacenter so that if the primary replica server fails, it...

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

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

  • RE: SQL Server 2012 Clustering Questions

    sellers.rick (3/12/2014)


    The current cluster is a pair of Dell servers (not sure of the model number) with Intel Xeon CPU E7-4830 @ 2.13 Ghz (32 cores), 128 GB RAM mirrored...

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

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

  • RE: Always on availablity group

    Martin Stephenson (3/12/2014)


    Perry Whittle (3/12/2014)


    Martin Stephenson (3/10/2014)


    test2 is the automatic failover synchronous non readable

    The readable secondary is not important at this time, what are the connection settings when in the...

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

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

  • RE: Always on availablity group

    You maybe need to read my 4 article on FCI and AO.

    Parts 1[/url] and 2[/url] have been published, 3 and 4 will follow soon

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

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

Viewing 15 posts - 3,466 through 3,480 (of 9,244 total)