Viewing 15 posts - 61 through 75 (of 5,841 total)
What you state is not possible if log shipping is working correctly. And I will go so far as to say it won't be a SQL Server bug either because...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 24, 2018 at 10:19 am
Definitely recommend getting a (good) consultant certified to work for you so they can be on standby to jump on as soon as the event starts occurring again. There are...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 24, 2018 at 10:17 am
There are a large number of things that could be in play here. I don't know that a forum is the place for them because it is an intermittent problem....
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 23, 2018 at 12:29 pm
I ignore what admins/devs tell me when digging into an outage scenario like this. The data I collect will do all the talking necessary almost without exception. And if you...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 23, 2018 at 12:21 pm
GilaMonster - Tuesday, January 23, 2018 11:48 AMCorruption is usually related to problems with the IO subsystem.
And those usually related to not...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 23, 2018 at 12:16 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 23, 2018 at 9:58 am
1) Glad you got it fixed.
2) "...I didn't even know where to begin..." - That is actually the single most important thing on this entire thread, and is...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 23, 2018 at 8:49 am
If you want to get your problems resolved ASAP, hire a professional tuning expert. You have given us essentially nothing to go on to help resolve what sounds like severe,...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 22, 2018 at 6:12 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 22, 2018 at 11:13 am
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 22, 2018 at 11:09 am
Log shipping is easiest, BY FAR. But like mirroring it does everything.
Since it sounds like you want a "SMALL" subset of tables, I would just create simple triggers...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 19, 2018 at 12:50 pm
Does your HOST and VM have a good bit more than 128GB of RAM available/reserved for the VM? If not that would be priority #1 in my book (unless you...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 19, 2018 at 12:47 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 18, 2018 at 10:06 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 18, 2018 at 10:04 pm
Just making statements of fact - nothing more sadly for you.
I think you should spin it up in XML in the engine inside the trigger. I hear that...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 17, 2018 at 8:12 pm
Viewing 15 posts - 61 through 75 (of 5,841 total)