Viewing 15 posts - 211 through 225 (of 6,400 total)
Option1 - Upgrade all your drivers to MSOLEDBSQL (or another driver which supports MSF) and use "MultiSubnetFailover=True" in your connection strings
Option 2 - you could set "RegisterAllProvidersIP" to false to only...
November 22, 2023 at 10:04 am
No you would need to use a linked server as it needs to resolve the read-write replica which could be any node.
If it was a select then that's a different...
November 22, 2023 at 9:47 am
Run a DBCC CHECKDB on the database, and see what it says is broken.
DBCC CHECKDB (UM_24_7) WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS, DATAPURITY, EXTENDED_LOGICAL_CHECKS
If nothing is returned then the...
November 17, 2023 at 11:05 am
the permission needed to execute the sp is view server state. it worked once i added
Cool, maybe open a PR with the MSFT docs then to update it to...
November 15, 2023 at 9:21 am
Rip it all out and start again.
Reduce the size of the publications to manageable / groupable sizes, eg all tables relating to inventory, all tables relating to finance, that way...
November 15, 2023 at 9:19 am
You need to be a sysadmin to run that procedure
Permissions
Execute permissions for sp_readerrorlog are restricted to members of the sysadmin fixed server role.
November 14, 2023 at 1:33 pm
Rip all the replication out and start it again from scratch.
3600 tables depending on your throughput may be an issue, you may want to look at splitting your publication into...
November 14, 2023 at 9:55 am
SQL needs to be running as an actual account, not NT SERVICE, so open SQL Config Manager and check what the services are running as.
Then if they are not a...
November 13, 2023 at 3:47 pm
You need to access UNC paths.
Ensure that the services are actually running as domain accounts, then grant the domain service accounts/MSA's/gMSA's access to the UNC paths.
The two virtual service accounts...
November 13, 2023 at 1:24 pm
Please post the full table definition, not just the 2 columns.
November 9, 2023 at 12:47 pm
Have you read the documentation, or done a simple search on this topic, as doing a basic google search for "logshipping delay restore" yields a lot of results.
November 9, 2023 at 8:08 am
View the live data before creating the database.
You only view data after the live data view has been opened, so if you create the database before viewing live data you...
November 3, 2023 at 8:21 am
Not had to do that in a hot minute, but last time I did it was 90% painless.
As long as you have an appropriate driver to connect to MySQL you...
November 2, 2023 at 3:54 pm
Are you able at all to post screenshots of the config pages, maybe a fresh pair of eyes can pinpoint the issue also?
November 2, 2023 at 2:35 pm
If you have a Visual Studio subscription, you are able to still download SQL2012 Dev for home lab use.
But saying 2012 is massively out of support now, you really shouldn't...
November 2, 2023 at 9:16 am
Viewing 15 posts - 211 through 225 (of 6,400 total)