Forum Replies Created

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

  • RE: Changing Locations of DataFile

    Paul Clark-418949 (10/11/2012)


    C: Drive - Operating System - (Filer01 - Volume 1)

    D: Drive - SQL Installation - (Filer02 - Volume 2)

    F: Drive - Page File - (Filer01 - Volume 3)

    G:...

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

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

  • RE: Log shipping failing all of a sudden

    Ok no problem

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

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

  • RE: Log shipping failing all of a sudden

    Lazy DBA (10/11/2012)


    We stopped the SQL Writer service, stopped the log shipping backup jobs and then re-initialized the log shipping by restoring a full backup.

    Other option was to find the...

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

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

  • RE: Log shipping failing all of a sudden

    How did you resume log shipping

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

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

  • RE: Changing Locations of DataFile

    Hi

    the links above will do you just fine, post back if you're still stuck

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

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

  • RE: error in backupjob logshipping

    who owns the sql server agent backup job?

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

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

  • RE: problem in mirroring

    can you provide detail about the backup regimes in place on the principal instance?

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

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

  • RE: Mirroring doubt

    saidapurs (10/11/2012)


    Thanks Pretty,

    Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.

    Thanks

    Satish

    Essentially, a...

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

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

  • RE: Mirroring doubt

    saidapurs (10/11/2012)


    Hi Gila/Perry,

    One of my great senior asked me below two questions and i gave the answer but he not agree, please response of your view..

    1....

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

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

  • RE: Cannot connect with "SQL Server" driver but I can with "SQL Server Native Client 10.0"

    ole 8332 (10/11/2012)


    Hello, hope someone can sort this out..

    I have this strange issue in my setup.

    In my connection string I cannot connect with "SQL Server" driver but I can connect...

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

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

  • RE: Mirroring doubt

    yes, the article details that.

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

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

  • RE: Cluster question...

    If the sql server service will not come online, check that all the dependant resources start successfully, you can see this in failover cluster manager. Take evrything offline and then...

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

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

  • RE: Log shipping failing all of a sudden

    Lazy DBA (10/10/2012)


    My log shipping was working for the past two years and now it has started failing with "cannot find a file that can be applied" or "Too recent"...

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

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

  • RE: Cluster question...

    Check the event logs for more info, there's bound to be an error there somewhere 😉

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

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

  • RE: move transaction log to a different drive.

    That is correct, you cannot drop the first created (primary) data or log file . If you want to move this you will incur some minimal downtime.

    Create your alter database...

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

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

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