Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 9,244 total)

  • RE: Should sql be installed by the account that will be running it?

    the service account should be low permisson. Setup grants all necessary permissions to the account (logon as service, etc) during install hence why you need to execute setup with admin...

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

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

  • RE: Uninstall an instance of MS SQL server 2005

    your welcome.

    uninstalling is fairly straight forward via the wizard, provided you don't hit any problems!

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

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

  • RE: Uninstall an instance of MS SQL server 2005

    throneofmight (8/11/2010)


    Any ideas on what is required to uninstall a SQL2005 instance that is running in a clustered set of servers?

    launch the installer from add\remove programs.

    select the clustered database engine...

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

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

  • RE: 2 node clustering recommendations for SQL 2008 (with windows server 2008)

    Sam -480699 (8/10/2010)


    Is it possible to create a 2 node (active / passive) cluster where the SQL databases are not using shared storage.

    Thats the whole point of a...

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

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

  • RE: what is Copy-Only Backup?

    TheSQLGuru (8/10/2010)


    I still refer to numerous 2005 features as "new". When you have been using the product since 6.5 first came out . . . 🙂

    In any case, BOL...

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

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

  • RE: Upgrade 2 node Clustered SQL Server 2005 on Windows 2003 to SQL Server 2008 on Windows 2008

    gmamata7 (8/9/2010)


    to see whether we can keep the same Virtual server name and SQL Server instance

    As I said the virtual network name, like a computername must be unique in the...

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

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

  • RE: Upgrade 2 node Clustered SQL Server 2005 on Windows 2003 to SQL Server 2008 on Windows 2008

    gmamata7 (8/9/2010)


    Can we have same Virtual server name with different IP?

    no you cannot, like a computername the virtual network name must be unique in the Windows domain

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

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

  • RE: Poll to see how many people set Max Server Memory

    if using BP locked pages then you should configure both min and max memory for each instance

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

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

  • RE: DR for SQL server 2005 and 2008 Clustering, any suggestion?

    jarupan (8/8/2010)


    1) Anyone has white paper about set up SQLserevr2008/Windows2008 on Virtual server (or VMware), please let me know the link.

    It's your lucky day!! Check the 2 links below for...

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

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

  • RE: 2 node clustering recommendations for SQL 2008 (with windows server 2008)

    Sam -480699 (8/9/2010)


    Hi,

    Apologies if this has been asked before I did try looking around for a similar thread.

    At the present moment my company has propsed that we need to...

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

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

  • RE: Failover cluster on XP SP2

    Hi Ashwin

    what you can do on XP is to set up a virtual SQL Server 2008 cluster. For this you will need the following

    multi core processor

    3 GB RAM

    Windows 2003 Server...

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

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

  • RE: what is Copy-Only Backup?

    let me re phrase that.

    New in SQL Server 2005!

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

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

  • RE: My MSDB Database is over 31 GB in the development server

    i'm assuming you're database mail, have you checked connectivity to the mail server?

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

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

  • RE: what is Copy-Only Backup?

    Hi

    copy_only is a new feature, it is basically a backup that does not interfere with the current backup chain. As Gail said, BOL does document this feature

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

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

  • RE: Upgrade 2 node Clustered SQL Server 2005 on Windows 2003 to SQL Server 2008 on Windows 2008

    tnk (8/8/2010)


    However, one idea might be to drop the passive node out of the 2003 cluster, upgrade to Windows Server 2008, set up the 2008 Cluster with a different cluster...

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

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

Viewing 15 posts - 7,801 through 7,815 (of 9,244 total)