Viewing 15 posts - 1 through 15 (of 38 total)
Make sure you are an administrator on the server. Also try: right click on the exe and run as administrator.
February 5, 2020 at 4:19 pm
I think we need an explanation from the author. Checksum was added in 2005. He backs up his answer with one broken link and one that doesn't mention this being...
May 14, 2019 at 3:28 pm
As soon as the re-init finished it started over again.
So I opened a ticket with Microsoft. The engineer had never seen replication behave like this before.
We removed...
April 20, 2017 at 12:26 pm
It's currently reinitializing from the snapshot. Log reader is enabled and running. Everything looks correct and we've matched all the settings to dev.
I'm going to let this run...
April 19, 2017 at 12:16 pm
Subscription watch list shows nothing for snapshot, and my subscription shows under transactional.
sp_helppublication shows 0 for replication frequency.
I see nothing out of the ordinary from sp_helpsubscription.
April 19, 2017 at 11:52 am
It is standard transactional replication. It's been running fine for about 9 months. I added a table yesterday and created a new snapshot. It reinitialized the publication with the snapshot...
April 19, 2017 at 10:43 am
Thanks for clarifying that Ed. I have to read more carefully and stop getting SQL 2008R2 vs. Windows 2008R2 mixed up in my head.
February 6, 2013 at 10:38 am
EdVassie (2/5/2013)
February 6, 2013 at 9:58 am
Think Geek has stuff that would make great prizes. I especially like the annoyatron.:cool:
March 9, 2010 at 5:14 pm
This can happen if your default database is deleted or off-line. Reset it to a database that exists.
December 7, 2009 at 9:35 am
Ryan:
Since you are altering security on the database it requires higher permission levels than most users.
From Books Online:
"Requires membership in the db_owner fixed database role. Only members of the sysadmin...
July 9, 2009 at 9:26 am
To add to Jack's reply.
The SID is how AD identifies an account. Just because you recreated the account with the same name, it's not the same account....
July 6, 2009 at 9:55 am
If you're going to plagiarize at least choose something that's true.
July 6, 2009 at 9:21 am
1. Everything Steve said.
2. why not use shrink (shrink file rather than shrink db) to shrink the log files? what are the downsides?
The downsides to shrinking in general...
December 26, 2008 at 10:24 am
Viewing 15 posts - 1 through 15 (of 38 total)