March 25, 2009 at 12:58 am
Hello all
Recently one of my server hanged while I was generating an initial snapshot for transactional replication process. I had to do hard reboot in order to bring the server online. The server is not production, so was not taking any load at all. Any reason why it might have hanged, anything that I can do to avoid the situation in the future. The server is slated for production so do not want to take a chance.
Thanks in advance.
March 25, 2009 at 12:55 pm
Hard to tell with just that. You will need to be able to reproduce the problem.
I have many large installations and even with the largest of the snapshots the servers do not Freeze or stall or go down.
I would update drivers, windows, and SQL Server to the fullest and try again 😉
* Noel
March 25, 2009 at 1:16 pm
Try not to run snapshot agent. I never do since it takes lots of resources. Alternatively
I backup and restore database to make them in synch .
once in synch i setup replication and i dont run snapshot agent since it always create problem for me as database is huge for me.
when you do it this way its much simple and fast as compare to runing snapshot agent. just make sure database is in full recovery mode before backup and restore to subscriber.
:crazy: :alien:
Umar Iqbal
March 25, 2009 at 1:48 pm
umar iqbal (3/25/2009)
Try not to run snapshot agent. I never do since it takes lots of resources. AlternativelyI backup and restore database to make them in synch .
once in synch i setup replication and i dont run snapshot agent since it always create problem for me as database is huge for me.
when you do it this way its much simple and fast as compare to runing snapshot agent. just make sure database is in full recovery mode before backup and restore to subscriber.
True using backup initialization has its advantages but there are features that you lose in the process too.
If you don't need to add articles dynamically then you are fine!
* Noel
March 25, 2009 at 2:45 pm
I know that when you generate snapshot, it can cause dead locks with the other operation. Maybe you should check your Log to see if there were Dead locks. That can cause the Server to be non responsive. I assume you have the flag for tracing Dead Lock set for your DB.
-Roy
March 26, 2009 at 12:18 am
Thank you so much for your response. Backup and Restore seems like a good idea but I have to add new articles to the publication, and hence generate a new snapshot.
March 26, 2009 at 6:41 am
Also check for Open transactions, Especially on the articles that are being snapshot.
-Roy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply