July 19, 2015 at 10:23 am
I'm new to replication.
I have experienced that when publishing an Article that things can go wrong.
Fortunately we are not in Production yet.
Do you have a test environment?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 12:50 am
Do you have a test environment?
Hi,
yes, I have a test environment.
Kind regards,
Andreas
July 20, 2015 at 1:43 am
Local instances, where I can do anything I want (within reason). I use this to check that my understanding is correct, before moving into:
Test Server - where my changes and any Developers changes are tested together, to make sure they work as expected. Once happy, these changes go to:
QA Server - as close a copy of the Live environment as we can manage. This is the last step before it transfers to:
Live Server.
Before the code is transferred to the QA server it should be peer reviewed by another DBA. Before it goes Live it is approved by the DBAs responsible for the Live estate.
And every level of testing includes a rollback, to ensure the change can be reversed if required.
This doesn't just apply to Replication changes - everything takes this route. All of the steps to install, confirm and rollback are documented - before it goes Live. If I get hit by a bus another DBA should be able to follow the instructions without any difficulty.
July 20, 2015 at 2:01 am
Thanks for the input.
My concern is that is I add a bunch of articles and I break replication and have to regenerate a new snapshot bec ause I missed a table that was referenced by a view.
I want to test the deployment of articles.
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 2:06 am
Hi,
it is not nessesary to break replication, only to add a new articel.
Please watch this link: http://saveadba.blogspot.de/2011/08/adding-new-article-without-generating.html
We use this once a week.
Regards,
Andreas
July 20, 2015 at 2:34 am
I added a view article and I missed one table referenced in the view.
I added over 100 articles but I missed one table.
When I ran the snapshot agent it bombed out and I was forced to generate a new snapshot.
I'm trying to avoid having to generate a new snapshot.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 2:58 am
Welsh Corgi (7/19/2015)
Do you have a test environment?
Always, for everything that's going to production.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2015 at 3:06 am
Thank you Gail. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 3:24 am
I have added 100 + articles to what is going to be the production Server.
Should I do an image of that Server and apply it to the test Server?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 11:17 am
I added Articles to be published but they did not make it to the subscriber.
Is there a way to force the articles to be applied?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 11:24 am
Hi,
could you check, if your article were stored on the distributor?
Every article should stored in the snapshot-folder.
And can you execute this query on the publication-database:
"sp_helppublication"
And, have you checked, when the snapshotagent was last executed?
Regards,
Andreas
July 20, 2015 at 11:33 am
I ran the snapshot agent several times.
The article was generated but it did not make it to the subscriber.
All of the other articles that I added since then did not make it either.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 20, 2015 at 11:41 am
Replication is not updating the subscriber for any objects.:ermm:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply