Viewing 15 posts - 211 through 225 (of 2,840 total)
This is just replication part you are doing. But I would advice you to take regular back ups (Once a day) and transaction log back ups. Your back up is...
November 15, 2011 at 1:55 pm
I am not sure I understand. You just need to have a transaction log back up. You do not have to restore the log to your subscriber DB. When you...
November 15, 2011 at 12:42 pm
Keep in mind that the data will be replicated only once every 15 minutes when the log back up is set for 15 minutes interval. I would recommend a smaller...
November 15, 2011 at 8:43 am
If it is a transactional replication and you have the option set Sync with back up (IsSyncWithBackup), the data will be replicated to your subscriber only when you do a...
November 15, 2011 at 8:18 am
Are there any network issues between the pub and the 2008 box? Do you see any network IO waits?
Are the two subscribers having the same HW configuration?
November 15, 2011 at 7:22 am
Can you run SELECT DATABASEPROPERTYEX('Your Database Name', 'IsSyncWithBackup'); and let me know what is the result?
November 15, 2011 at 7:15 am
Also how was the DB in the subscriber initialized? Was it Snapshot or Sync with back up?
November 15, 2011 at 6:53 am
Did you try pushing a token across?
November 15, 2011 at 6:51 am
Take a look at this solution provided at MS forums.
November 15, 2011 at 6:50 am
Hi Andris,
Can you clarify something for me? What do you mean by "But i need now synchronize automatic all time from my distribution server to suscriptor server. " ? I...
November 15, 2011 at 6:44 am
What error does it show?
Try adding a token and see if that token is successful.
November 15, 2011 at 6:43 am
It took me two days to give Steve the editor some work. I managed to upload my article using the editor. 😀
November 11, 2011 at 1:59 pm
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA and be a...
November 11, 2011 at 7:41 am
The first part of my 3 part series of articles on SQL Audit will be be out on 28th of this month. I am right now trying to upload the...
November 11, 2011 at 7:14 am
I have never faced this issue. We have done snapshots for tables that have millions of rows but we usually try to do the population by ourself if we can...
November 10, 2011 at 6:46 am
Viewing 15 posts - 211 through 225 (of 2,840 total)