Forum Replies Created

Viewing 15 posts - 826 through 840 (of 9,244 total)

  • RE: There is insufficient system memory in resource pool 'internal' to run this query.

    smartin 3811 - Wednesday, April 5, 2017 3:15 PM

    Since migrating to sql 2014 with SP2 we are getting this error (There is...

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

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

    April 6, 2017 at 7:17 am

    #1937028

  • RE: Rebooting clustered SQL 2014 problem

    Raymond van Laake - Thursday, April 6, 2017 1:58 AM

    Hi there, 
    I reboot our clustered SQL 2014 (2 nodes, in VMWare environment) regularly. The...

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

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

    April 6, 2017 at 7:15 am

    #1937026

  • RE: Rebooting clustered SQL 2014 problem

    RVSC48 - Thursday, April 6, 2017 6:52 AM

    Sql Server, during a cluster failover, performs a restart of the sql instance, which in...

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

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

    April 6, 2017 at 7:14 am

    #1937025

  • RE: server name and network server name not the same

    how far have you got, is replication enabled, more detail please.

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

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

    April 5, 2017 at 4:58 am

    #1936755

  • RE: Step by Step Configuring AlwaysOn with Log Shipping

    No need to disable the jobs just insert a new job step at the beginning which checks whether the replica is primary or not

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

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

    April 3, 2017 at 12:41 pm

    #1936397

  • RE: Page File location and Size

    The page file is used for so much, but primarily is the vehicle for kernel dumps during a Windows Server issue.
    The page file should be on separate volume to...

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

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

    April 3, 2017 at 7:30 am

    #1936278

  • RE: How to archive old data from sql database

    Jeff Moden - Saturday, April 1, 2017 8:48 PM

    If you don't want to go the table-partitioning route, then write a proc to...

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

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

    April 3, 2017 at 7:19 am

    #1936273

  • RE: Database backups Vs VM backups

    this is essentially placing the database backup management outside of the DBA, if the company is haapy with that and that rerstores will be performed by someone who is not...

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

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

    April 3, 2017 at 7:12 am

    #1936266

  • RE: 2016 Cluster Questions For Always On but also with other services

    GilaMonster - Friday, March 31, 2017 11:55 AM

    Perry Whittle - Friday, March 31, 2017 11:07 AM

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

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

    April 3, 2017 at 7:01 am

    #1936258

  • RE: tempdb data and log file

    sqlguy80 - Saturday, April 1, 2017 1:33 PM

    Hi,
    We have some reporting queries which use tempdb very heavily and I get alerts from...

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

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

    April 3, 2017 at 6:52 am

    #1936256

  • RE: Moving a database with DMK to AlwaysOn AG

    ayemya - Thursday, March 30, 2017 11:39 AM

    I am not able to restore SMK from from primary to secondary when different service...

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

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

    March 31, 2017 at 11:15 am

    #1936032

  • RE: Multi-Site Cluster SQL Server 2016 AlwaysON Infrastructure

    myalliku - Thursday, March 30, 2017 2:28 PM

    I thought maybe i can combine two cluster in one cluster like below. As you...

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

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

    March 31, 2017 at 11:13 am

    #1936030

  • RE: 2016 Cluster Questions For Always On but also with other services

    GilaMonster - Wednesday, March 29, 2017 2:56 PM

    Yes, but a cluster with all services, and trying to merge failover cluster and AG...

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

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

    March 31, 2017 at 11:07 am

    #1936028

  • RE: Moving a database with DMK to AlwaysOn AG

    why do you have a DMK created in the user database

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

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

    March 30, 2017 at 10:04 am

    #1935771

  • RE: Data file autogrowth instead of available free space use

    depends on what was happening, if the file attempts to autogrow and fails the action will rollback leaving what looks to be sufficient free space. Something obviouslt tried to use...

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

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

    March 30, 2017 at 10:02 am

    #1935770

Viewing 15 posts - 826 through 840 (of 9,244 total)