Viewing 15 posts - 1 through 15 (of 2,839 total)
In Publication properties, it is best to mark it as "Subscriptions never expire".
Also you could execute the below to bring it back to normal state.
USE distribution
GO
Update [MSsubscriptions]
Set [status] = 2
where...
-Roy
March 11, 2022 at 1:57 pm
Hey Jeff,
You managed to bring life to a post that is a decade old? 😛
-Roy
March 11, 2022 at 1:01 pm
This is how I see it. PASS has become a corporate machine. I was very much involved in PASS for a very long time. In the beginning everything was peachy....
-Roy
June 19, 2020 at 12:53 pm
You could always use Standard edition for subscriber which is not that expensive for reporting and use Transactional replication.
-Roy
December 10, 2018 at 5:11 am
You can take a look at sys.sp_identitycolumnforreplication
-Roy
December 10, 2018 at 5:03 am
There are times the queries take bad plan if the IN parameter datatypes does not match the table definition. Do you have any control over the code in the OLTP...
-Roy
December 10, 2018 at 5:00 am
Thank You. This is the best suggestion I have so far and makes sense. I have been asking it on twitter too and did not get any good suggestion.
-Roy
September 11, 2017 at 10:13 am
1 Mil is a pretty good number. When we look at Sentry we do see around that range write bytes on our Env.
On another note, will you be at...
-Roy
October 19, 2016 at 7:22 am
Under what user is the service running? Under your name or a service account. If the service is not running under your account, it does not matter whether you have...
-Roy
November 13, 2015 at 7:08 am
Did you take a copy of the files before you deleted?
Like Gail asked, did you check the permission before you deleted those files?
-Roy
November 13, 2015 at 5:30 am
What is the user under which the SSIS is running? The target server and host server, does it also have the same username and password?
-Roy
November 12, 2015 at 11:18 am
You can make it granular...
You could give just execute permission on sp_help_jobhistory (They need to know the name of the job I think)
Or give them select permission to sysjobhistory...
-Roy
November 11, 2015 at 7:42 am
Give access to the role SQLAgentReaderRole is MSDB Database.
-Roy
November 11, 2015 at 7:08 am
Since all the disks are SSDs we did not think of separating the TxLog into a separate LUN. We have seen ASYNC Network IO Waits but never Disk IO. That...
-Roy
September 1, 2015 at 12:41 pm
It wasnt log back up for sure. This happened at 11:44. Our Log back up runs at 11:55. The batch request per second never went more than 1600 per sec...
-Roy
September 1, 2015 at 12:15 pm
Viewing 15 posts - 1 through 15 (of 2,839 total)