Forum Replies Created

Viewing 15 posts - 451 through 465 (of 9,244 total)

  • RE: SQL Server detected a logical consistency-based I/O error: invalid encryption key

    start the instance in single user mode to check master database

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

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

    January 3, 2018 at 4:24 am

    #1974182

  • RE: Multiple AG groups in one Windows failover cluster?

    AlexSQLForums - Tuesday, January 2, 2018 2:25 PM

    Is each AG in synchronous mode in the same Data Center and asynchronous mode...

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

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

    January 3, 2018 at 4:21 am

    #1974181

  • RE: SQL Server detected a logical consistency-based I/O error: invalid encryption key

    iyarianecy10 - Tuesday, January 2, 2018 8:51 AM

    I tried to rebuild the master db following  this , scenario 2 and 3 as...

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

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

    January 2, 2018 at 8:55 am

    #1974084

  • RE: Splitting TempDB across multiple files

    Jeff Moden - Tuesday, January 2, 2018 6:19 AM

    Perry Whittle - Tuesday, January 2, 2018 5:12 AM

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

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

    January 2, 2018 at 8:53 am

    #1974083

  • RE: Shrink all user database files

    short answer is don't!!

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

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

    January 2, 2018 at 8:49 am

    #1974078

  • RE: Splitting TempDB across multiple files

    Tava - Wednesday, December 27, 2017 6:38 PM

    I have a question regarding the splitting of TempDB in SQL Server, I know its...

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

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

    January 2, 2018 at 5:12 am

    #1974038

  • RE: inplace upgrade for 2014 to 2016 with readable secondary.

    tcronin 95651 - Wednesday, December 20, 2017 2:49 PM

    I will be taking a VMWARE based 2014 AG that has one active and...

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

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

    December 21, 2017 at 8:30 am

    #1973094

  • RE: Check DB failed

    ramyours2003 - Wednesday, December 20, 2017 9:00 AM

     and also in job log  we found

    Msg 233, Sev 16, State 1: Communication link...

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

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

    December 20, 2017 at 10:56 am

    #1972961

  • RE: Restore full backup at first and restore diff backup later, can I?

    Jeff Moden - Wednesday, December 20, 2017 8:56 AM

    Perry Whittle - Wednesday, December 20, 2017 5:08 AM

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

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

    December 20, 2017 at 10:55 am

    #1972960

  • RE: Enabling RCSI

    alex.palmer - Wednesday, December 20, 2017 8:21 AM

    Straight off the bat I worry that the overnight batch processes may "rely" on SELECTs being...

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

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

    December 20, 2017 at 8:25 am

    #1972910

  • RE: Enabling RCSI

    alex.palmer - Wednesday, December 20, 2017 06:00 AM

    I know to enable it I just a drop down  in SSMS, but doing so may impact results returned by code.

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

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

    December 20, 2017 at 8:09 am

    #1972906

  • RE: Enabling RCSI

    alex.palmer - Wednesday, December 20, 2017 6:00 AM

    Read this link and then tell me I don't need to be concerned about code 😉

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

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

    December 20, 2017 at 8:05 am

    #1972905

  • RE: Enabling RCSI

    alex.palmer - Wednesday, December 20, 2017 4:40 AM

    Hi

    I'd like to be able to enable RCSI on some of our databases.

    I know that...

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

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

    December 20, 2017 at 5:16 am

    #1972878

  • RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

    NewBornDBA2017 - Tuesday, December 19, 2017 9:43 AM

    One of the user who has DB owner rights on the database(dbs-sqlprod4), trying to access...

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

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

    December 20, 2017 at 5:14 am

    #1972877

  • RE: Check DB failed

    ramyours2003 - Tuesday, December 19, 2017 8:30 AM

    in one of my server CHeck DB failed due to the below error

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

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

    December 20, 2017 at 5:11 am

    #1972875

Viewing 15 posts - 451 through 465 (of 9,244 total)