Viewing 15 posts - 106 through 120 (of 1,079 total)
Run Profiler against the secondary non-readable instance to catch attempted sessions and logins being made to the instance.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 2:25 pm
Are you doing this on your non-readable secondary database? If yes, then you are seeing the correct message.
It has to be the Primary (RW) or at least Readable Secondary...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 2:08 pm
That error will only present itself if you have an AG, and applications/users are trying to run update/delete/inserts to the secondary instance/replica DB.
Trace where those queries are coming from,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 1:37 pm
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/creation-and-configuration-of-availability-groups-sql-server
https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 9:33 am
Eric Mamet - Friday, May 19, 2017 9:01 AMHad never heard of the RAW option.I'll give that a shot (on Monday!)
Thanks
It...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 9:08 am
Have you tried the -C options with RAW?
-C { ACP | OEM | RAW | code_page }
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 8:57 am
Did you restart SQL after sp_drop and sp_addserver? You need to.
Be sure to perform the SP steps:
sp_dropserver <old_name>;GO
sp_addserver <new_name>, local;GO
When checking...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2017 at 3:57 am
No, but you will lose the option to backup Transaction logs and restore from thereon.
Recovering might end up in data loss.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 18, 2017 at 10:16 am
Provide the table DDL and insert script for some sample data please.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 18, 2017 at 9:56 am
Please post DDL and sample data for quicker assistance.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 18, 2017 at 9:18 am
I've seen 'dbo.SORT' being full specifically when you have set to sort an index rebuild to SORT_IN_TEMPDB.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 18, 2017 at 8:35 am
From your post I assume you have some layer of virtualization, and all VMs running on this one host.
If you have an EA, you should fully license all the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 18, 2017 at 8:31 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 16, 2017 at 6:13 am
Have you considered data compression?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 16, 2017 at 6:04 am
Use one cube and apply dimension permissions to each company for their data only....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 28, 2017 at 12:42 pm
Viewing 15 posts - 106 through 120 (of 1,079 total)