Forum Replies Created

Viewing 15 posts - 6,406 through 6,420 (of 9,244 total)

  • RE: Install problem adding 2nd node to failover

    Have you ensured that all required storage has been presented to the new node

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

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

  • RE: Testing Cluster Failover

    Jack, the easiest way to test a failover of the cluster is to kill the public network connection on the active node. This should cause failover to a partner node....

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

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

  • RE: Any help in troubleshooting this sql 2008 enterprise ???????

    What's in the windows application and system logs?

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

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

  • RE: DBCC CHECKDB fails

    Minnesota - Viking (10/11/2011)


    Looking at the object IDs say that they are:

    DEFAULT_CONSTRAINT and

    PRIMARY_KEY_CONSTRAINT

    cant i get away by recreating these ?

    The default constraint shouldn't be to much of an...

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

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

  • RE: Upgrading Database / Copying Database Questions

    kevinsql7 (10/10/2011)


    We are running SQL Server 2005 (SP3) on Windows 2003 Server. What is the best method to use to upgrade SQL Server 2005 Databases to SQL Server 2008. For...

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

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

  • RE: DBCC CHECKDB fails

    can you provide more details of the move from 2000 to 2008.

    Did you run DBCC CHECKDB after the upgrade and did it run successfully?

    Did you run DBCC UPDATEUSAGE after the...

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

    "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

    the dbcreator server role will grant create drop and restore permissions to any database. Securables at the database level are used to grant the BACKUP permissions or just grant the...

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

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

  • RE: Central management of sql servers

    sql server 2008 central management server??

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

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

  • RE: SQL Server is restarting every time

    do you have antivirus software on the server, if so have you perfomed a system scan?

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

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

  • RE: SQL Server is restarting every time

    So nothing at all then. No stop errors or application errors, etc.

    Almost sounds like some ones pulling the plug out!!

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

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

  • RE: SQL Server is restarting every time

    Perry Whittle (10/11/2011)


    have you checked the Windows event logs?

    ?

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

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

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

    mohammed moinudheen (10/11/2011)


    Another doubt I have is. Do these IP addresses that needs to be configured on ClusterDC, Node1 and Node2 needs to match to what was configured on Part...

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

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

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

    mohammed moinudheen (10/11/2011)


    Sorry, I have one doubt, please don't get mad. It is regarding the below IP addresses you suggested.

    VMNet1 Public 172.168.10.0 255.255.255.0

    VMNet2 ...

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

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

  • RE: SQL Server is restarting every time

    have you checked the Windows event logs?

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

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

  • RE: GO vs ;

    Dev @ +91 973 913 6683 (10/11/2011)


    I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.

    Oracle uses it too

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

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

Viewing 15 posts - 6,406 through 6,420 (of 9,244 total)