Viewing 10 posts - 1 through 10 (of 10 total)
try in CMD with administrative privileges setup.exe /ACTION=UPGRADE
June 9, 2023 at 8:49 pm
make the publication property allow_anonymous and immediate_sync false, reinitialize publication with a new snapshot.
June 25, 2019 at 1:28 pm
1> make the publication
EXEC sp_changepublication
@publication = N'Publication_Name',
@property = N'allow_anonymous',
@value = 'FALSE'
GO
EXEC sp_changepublication
@publication = N'Publication_Name',
@property = N'immediate_sync',
@value = 'FALSE'
GO
2> reinitialize publication
3> after you see in distributor to subscriber history no replication...
June 25, 2019 at 1:24 pm
use bracket [ ] around your db and linked server; like [DatabaseName] [linkedServer].
'['+cast (ss2.data_source as varchar)+']',
September 4, 2018 at 9:55 am
Dear; I create perfect alwayson solution as per my perspective on two node cluster. The failover works great, the read intent connection routing works great, I already check with the profiler. The question...
March 20, 2018 at 2:29 pm
Database set to sync mode. I understand listener is stand on WSFC role but the problem is that i can not read or write in e.g Server A (primary) and...
March 20, 2018 at 9:30 am
SeniorITGuy (8/9/2016)
January 3, 2018 at 2:38 pm
go to the following a link
https://www.microsoft.com/en-us/download/details.aspx?id=29065&ocid=aff-n-in-loc--pd
Expand Install Instruction
find following files January 30, 2017 at 10:06 am
add MAXTRANSFERSIZE= 1048576
e.g
DBCC TRACEON (3605, -1)
DBCC TRACEON (3213, -1)
BACKUP DATABASE [xyz_hist ] TO
DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz0.bak',
DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz1.bak',
...
October 6, 2016 at 2:00 pm
Check any db is in recovery mode
August 8, 2014 at 1:35 pm
Viewing 10 posts - 1 through 10 (of 10 total)