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...
-Roy
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...
-Roy
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...
-Roy
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...
-Roy
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?
-Roy
November 15, 2011 at 7:22 am
Can you run SELECT DATABASEPROPERTYEX('Your Database Name', 'IsSyncWithBackup'); and let me know what is the result?
-Roy
November 15, 2011 at 7:15 am
Also how was the DB in the subscriber initialized? Was it Snapshot or Sync with back up?
-Roy
November 15, 2011 at 6:53 am
Did you try pushing a token across?
-Roy
November 15, 2011 at 6:51 am
Take a look at this solution provided at MS forums.
-Roy
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...
-Roy
November 15, 2011 at 6:44 am
What error does it show?
Try adding a token and see if that token is successful.
-Roy
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. 😀
-Roy
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...
-Roy
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...
-Roy
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...
-Roy
November 10, 2011 at 6:46 am
Viewing 15 posts - 211 through 225 (of 2,840 total)