Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 9,244 total)

  • RE: Log Shipping - Change DB owner of Secondary

    to modify the Secondary you'll need to perform a LS role reversal to bring the Secondary up. once you complete your actions you'll then need to perform a LS role...

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

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

  • RE: Failover - Always On Environment

    read the whole stairway before making any firm decision 😉

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

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

  • RE: Grant DROP table permission to SQL id

    balasach82 (3/26/2015)


    How to grant DROP table permission within a database to an SQL login. I could see in Databae properties-> permission tab, there is an option to grant CREATE TABLE,...

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

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

  • RE: Failover - Always On Environment

    Jako de Wet (3/27/2015)


    I have had a look at Failover Clustering and Availability Groups. I am leaning more towards AG as we can use the optimised local RAID drives on...

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

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

  • RE: Exception while setup Mirroring in workgroup environment

    anand.mind (3/26/2015)


    Hi,

    I have two servers (ServerA and ServerB) on cloud having SQL Server200R2 (64bit) installed on Windows Server 2008 connected with Workgroup. ServerA has default instance InstA and ServerB...

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

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

  • RE: Steps in sequence to apply OS patch for mirror and principal servers without affecting database

    Joy Smith San (3/26/2015)


    Hi,

    Mirroring has been configured for one of our database.

    OS team wants to apply some patch for windows. Whats the best approach to do it in both...

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

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

  • RE: DBCC CHECKDB WITH DATA_PURITY

    gs1975 (3/27/2015)


    Hi,

    We are currently planning a side-by-side SQL Upgrade from 2008r2 to 2014.

    One of the post-Upgrade checks I would like to do is to run DBCC CHECKDB WITH DATA_PURITY against...

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

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

  • RE: LOG SHIPPING SCEANAIO

    Arjun SreeVastsva (3/25/2015)


    Hi,

    I have manully faill overed server B as primary server

    Please detail the steps you took??

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

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

  • RE: Occurrence of unexpected and automatic failover in a mirroring environment

    this is exactly what I would expect when you put the witness on your mirror site!

    Either put the witness on a totally separate site to the mirror and the principal...

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

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

  • RE: Availability Group Error

    Ratheesh.K.Nair (3/26/2015)


    Our application team does upgrades and when they do the same they rename the primary database in Always On availability group remove secondary from AG, before that we disables...

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

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

  • RE: AlwaysOn with 3 node FCI and Availability Groups with WSFC, Primary on FCI node 1, if failover, how HAG will work?

    Pablo Campanini-336244 (3/25/2015)


    Thanks for your response, at this point we do not have WSFC, we just have FCI with those 3 nodes.

    If you have a Failover Cluster Instance then...

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

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

  • RE: Database Backup Failure SQL Server 2012 Enterprise

    Anandita Sharma (3/24/2015)


    Write on "O:\sql_bak\At_full1.bak" failed: 112(There is not enough space on the disk.)

    The above message is pretty clear, as already suggested you could try using compression

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

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

  • RE: Install System Databases to a non default drive

    the installer will automatically dump the logs for each system database in the directory for the data file, you'll need to move them manually, which to be honest, there's no...

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

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

  • RE: Level 6: Analyse & Deploy an AlwaysOn Availability Group

    yusufkothari (3/25/2015)


    can you point me to any online resource in meantime...

    Not at this present time, there are numerous scripts available

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

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

  • RE: Level 6: Analyse & Deploy an AlwaysOn Availability Group

    prince_william (3/25/2015)


    Are there prerequisites to location of the failover cluster nodes in AD? I have seen cases where I need to move all nodes and cluster objects to COMPUTER...

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

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

Viewing 15 posts - 2,236 through 2,250 (of 9,244 total)