Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 9,244 total)

  • RE: Log and Data placement on a SAN.

    Found it, it's fixed in SP1 CU10. This link[/url] details the issue

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

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

  • RE: Log and Data placement on a SAN.

    there is also a bug in the failover cluster install whereby you elect to install shared component files to D:\program files\MSSQL instead of C:

    you go to your next node and...

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

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

  • RE: Stopping Services in an Active\Passive Cluster

    Jpotucek (10/13/2010)


    What I want to do is bring SQL Server down while they do the actual server backups

    Take all SQL Server resource groups offline, this will offline all the...

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

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

  • RE: Stopping Services in an Active\Passive Cluster

    Jpotucek (10/14/2010)


    Do you think I should only take the Cluster Group offline

    No that would disable access to the cluster! This group will go offline when the last cluster node shuts...

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

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

  • RE: Stopping Services in an Active\Passive Cluster

    Are we talking windows 2003 or 2008 cluster here?

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

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

  • RE: @@VERSION at odds with SP2 uninstall

    try posting on the MSDN forums may help.

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

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

  • RE: Connect to SQL Server using I/P address in SSMS

    RaviShankar1234 (10/13/2010)


    I'm not able to connect to it even if I give i/p address with port number associated with Instance2

    what format are you using to specify the ip and port...

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

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

  • RE: @@VERSION at odds with SP2 uninstall

    have you informed MicroSoft product support?

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

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

  • RE: Stopping Services in an Active\Passive Cluster

    as soon as you install SQL Server into a clustered environment it sets the service startup to manual on all nodes (imagine if 2 nodes both had the services set...

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

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

  • RE: How to remove/uninstall Management Data Warehouse

    No problem, the annoying thing is there are other issues with PDC which aren't fixed until at least SP1 CU7.

    Thing is it is a new technology in SQL server and...

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

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

  • RE: slipstream sqlserver 2008 standard sp1

    george sibbald (10/13/2010)


    and SP2 is out so perhaps you should slipstraem that.

    Maybe in your test environment only at first 😉

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

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

  • RE: Add memory to sql server

    min and max memory settings are indeed dynamic. use the following query to set these

    exec sp_configure 'Show advanced options', '1'

    reconfigure

    exec sp_configure 'min server memory (MB)', 'valueinMB'

    exec sp_configure 'max server memory...

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

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

  • RE: slipstream sqlserver 2008 standard sp1

    yes!!

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

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

  • RE: How to remove/uninstall Management Data Warehouse

    this is a real problem and many have complained! Don't use scripts to remove the default collection set jobs as you will have issues if you try to re enable...

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

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

  • RE: SQL Server 2008 MS DTC

    Halcyon (10/12/2010)


    we have got service going down and not being restarted

    Thank you

    Sounds dire and beyond the scope of forum posts. What is your location, I am available on a contract...

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

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

Viewing 15 posts - 7,561 through 7,575 (of 9,244 total)