Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 9,241 total)

  • RE: Corrupt Backup File ?

    homebrew01 (11/18/2013)


    My goal is to make best use of the 4 G ram that I have, and address the apparent Linked Server issues I am having.

    As I said before then,...

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

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

  • RE: Corrupt Backup File ?

    homebrew01 (11/18/2013)


    boot.ini has /PAE, but not /3gb

    With your current OS and app config putting /PAE into the boot.ini has done little more than force you to reboot the server 😉

    Windows...

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

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

  • RE: Corrupt Backup File ?

    homebrew01 (11/18/2013)


    Perhaps tomorrow I will reduce SQL RAM to 2.5 G, and add the -g700 setting, then restart.

    If you dont have AWE enabled correctly and you set the -g700 startup...

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

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

  • RE: delete certain nodes

    sstacy7 (11/17/2013)


    How do you delete

    Are you referring to cluster nodes?

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

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

  • RE: Corrupt Backup File ?

    homebrew01 (11/10/2013)


    I rebooted this morning.

    I thought AWE was set correctly. I'll have to read up on it ... forgot the details.

    I just ran:

    sp_configure 'awe enabled', 1

    RECONFIGURE

    You also need to...

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

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

  • RE: How to make database back to standby mode

    rajeshjaiswalraj (11/15/2013)


    Hi All,

    before my database was in standby i make it online using

    restore database <name> with recovery

    but now again i want to put my database in standby

    can any one...

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

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

  • RE: An error while copying database

    SQL_Surfer (11/17/2013)


    can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.

    install the trial version of Litespeed and use that to compress and move...

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

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

  • RE: cluster sql service settings

    The failover tab details whether fail back of the resource occurs to a preferred node. It also specifies that if multiple failures occur within a given time period the application...

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

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

  • RE: cluster sql service settings

    This link details the policies tab

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

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

  • RE: Availability Group Question

    If you do join a clustered instance to an AO group you will not be able to use automatic failover.

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

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

  • RE: Error installing SP2 CU1 sqlserver 2008 R2 SP1 CU1

    javirsantos (11/15/2013)


    When I install the SQL SERVER 2008R2 SP2 CU1 offline disks fails and leaves the failed instances (clustered).

    I roll online and instances discontinuous work well.

    When you uninstall CU1 fails...

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

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

  • RE: clustering- quorum drive

    You should still be able to move it using the commands above, works just fine for me

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

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

  • RE: clustering- quorum drive

    Can you post the output please

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

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

  • RE: Log Shipping

    can you detail the steps you used to deploy the log shipping plan and whether using GUI or scripted

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

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

  • RE: clustering- quorum drive

    muthyala_51 (11/14/2013)


    I tried it on a test server using the command prompt command. I can move the cluster group but i still see the quorum drive on the passive node...

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

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

Viewing 15 posts - 3,871 through 3,885 (of 9,241 total)