Viewing 15 posts - 196 through 210 (of 2,840 total)
As far as I know when a Back up is done, it preserves the Stats as well.
November 23, 2011 at 7:47 am
If all the DB's belong to the same company why would I be worried about having one DBO that controls all the Schema? You can have one maintenance tasks that...
November 23, 2011 at 6:16 am
If it is a Windows authenticated user that is getting failed login, it should write it to the event viewer security log.
You could also run a trace for just...
November 23, 2011 at 6:10 am
If you are planning to use the back up in QA then I would suggest before. Then the QA does not need to do a Update stats. I have not...
November 23, 2011 at 6:06 am
I have never tried doing that. You probaly will have to populate the table by yourself. BCP OUT and BCP IN. But below is the way you add an article...
November 21, 2011 at 7:13 am
Koen Verbeeck (11/20/2011)
WayneS (11/18/2011)
:w00t::w00t::w00t:Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.
Congrats!
From me as well.
November 21, 2011 at 6:19 am
When you have both the Log reader and distributor on your the same box, you will see a performance impact. It is not THAT heavy but it will still have...
November 18, 2011 at 12:30 pm
There could be two reasons for this error.
1. Memory issue. If your server has low memory then this error can happen
2. Deadlocks. When this step is done, it locks the...
November 18, 2011 at 8:07 am
There are some great queries done by Glenn Berry. Check for his Super DMV queries. It will give you an idea of what are the bottle necks on the SQL...
November 18, 2011 at 5:24 am
When you have a read only Transactional replication, you are not supposed to do any DML operation on the Subscriber.
From what I understood from your post, you deleted a...
November 16, 2011 at 1:44 pm
The best way is to insert back the row you deleted in the subscriber.
November 16, 2011 at 12:37 pm
Ninja's_RGR'us (11/16/2011)
L' Eomot Inversé (11/16/2011)
November 16, 2011 at 10:36 am
The output is correct for your set up. When the output is 1, then means that your replication set up is Sync with back up. When you have that set...
November 16, 2011 at 6:14 am
That means it is not set to Sync with back up. It should be propagating the changes to Subscriber without much latency. Since you restarted the replication again keep monitoring...
November 16, 2011 at 5:57 am
You have a better HW on the 2008 server. So we can forget about that. Couple of things you might want to look at is the Disk configuration.
Are both the...
November 16, 2011 at 5:52 am
Viewing 15 posts - 196 through 210 (of 2,840 total)