Forum Replies Created

Viewing 15 posts - 6,436 through 6,450 (of 9,241 total)

  • RE: Failover Cluster - Add node

    derekr 43208 (10/10/2011)


    Hi Guys

    I have SQL 2008 enterprise Sp2 installed on Windows 2008 enterprise.

    This is a single node cluster

    What is the process of adding a second node to this cluster?

    Has...

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

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

  • RE: vmware and sqlserver

    VMWare does page, which edition\version are you using?

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

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

  • RE: Sql server 2005 Table Partition

    In SQL Server 2005, all tables are essentially partitioned by default, they all exist in a default first partition (check the tables sys.partitions and sys.allocation_units). You will need to examine...

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

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

  • RE: Best practices for granular access to production databases for non-DBA users

    praveen_vejandla (10/10/2011)


    We would like to streamline access to production SQL Servers such that non-DBA users will not have sysadmin privileges

    that is the recommended practice.

    praveen_vejandla (10/10/2011)


    but they should still be able...

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

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

  • RE: vmware and sqlserver

    which VMWare edition are you using?

    where do you see the 8GB assignment?

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

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

  • RE: SQL server back up

    luluwang205205 (10/10/2011)


    i want to recommend easeus todo backup, it provide advanced backup scheduler and one-click to recover system to dissimilar hardware, incremental backup, differential backup, backup SQL server/ Exchange...

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

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

  • RE: License questions

    sqlfriends (10/9/2011)


    I heard from another DBA, for a testing server which is only used for testing not for production, as long as the each developer using the testing server has...

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    All you did in part 1 is setup the subnets. Within each machines OS you have to assign an IP in the relevant range. If you need to you could...

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

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

  • RE: Automatic Alert Generation in the event of SQL Server Cluster Failover

    Jack Corbett (10/6/2011)


    Certainly an out of the box method to be notified of a failover. As mentioned it has some issues, but certainly could be part of an overall...

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

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

  • RE: database is in suspect mode (sql server 2008 R2 version)

    Put the database in emergency mode and run dbcc checkdb with message output first to ascertain exactly what the extent of the damage is. As Gail pointed out, the repair...

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    For this section create 3 new Windows virtual machines.

    1 of them requires just 1 virtual NIC connected to the public network.

    The other 2 require 3 virtual NICs each. One connected...

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

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

  • RE: Backup Software Selection

    homebrew01 (9/8/2011)


    I liked Idera's tool at my previous job, but now use Redgate backup which is ok too.

    Most tools offer a free trial so you can try them out.

    Isnt the...

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

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

  • RE: License questions

    sqlfriends (10/8/2011)


    For testing server, as long as each developer who connect to the testing server have a dev edition license, the server doesn't need a license itself.

    You're referring to...

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

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

  • RE: License questions

    sqlfriends (10/8/2011)


    Perry Whittle (10/8/2011)


    In SQL Server 2008 R2, developer is licenced and featured the same as datacenter. You can have as many testers connect as required. The key point of...

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

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

  • RE: Live Your Life

    Steve, he was a true icon of our time. He brought so many innovative products to the computer world and totally revolutionalised the smart phone market. What else could he...

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

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

Viewing 15 posts - 6,436 through 6,450 (of 9,241 total)