We have set 'Initialize with backup' while intialially restoring the backup over subscriber.My question is
When there is a failure on sunscriber or agent will I be able to reintialise the snapshot without changing any setting?
View Complete Post
I have the log backup setup every 15 minutes on the production server by using the below command
BACKUP LOG marcus8 TO DISK='NUL:'
The reason I use this command is we dont need point in time recovery and top of that we dont have storege for Log backups.
My question now is can I setup transactional replication with this setup in place or do I need to store the TLogs physically?
I am setting the transactional replication.My boss is worried about the point in time recovery on the subscriber if anything failson the subsciber .My question is I know we have log retention period of 2-3 days by default . Will that not take care of replaying
the logs from publisher when there is a failure on the subsciption or distributor level?
Im running transactional replication sql 2008 and have a couple table names with the same name but different schemas. I want to make sure in the replication that the filegroups stay with the subscriber. Is this possible?
Table AAA.Customer on file group A
Table BBB.Customer on file group B
Is there a way to keep these filegroups without rebuilding the index after it has been moved? I noticed there was an option in the replicaiton options to keep file group but it doesn not seem to help. Can you let me know how. THANKS>
I am newbie to SQL 2005 and doing my first project (I am an exchange/AD Consultant). I am trying to do a transactional replcation across a VPN link. I have humdreds and hundreds of tables to be replicated. I have around 100 tables which are
without any primary key. I am using
http://blogs.techrepublic.com.com/howdoi/?p=123 for configuration.
I am able to replicate the tables which are with Primary keys, can't replicate any tables which are without primary keys. I am sure there must be a work around or some solution for the tables without primary keys.
I have a Database which contains about 15 tables that 10 of them should be replicated to another database which its schema is "EXACTLY" same with the publisher. The 5 tables that are not planed to publish, have no rows all over the time (indeed the subscriber
DB is just a template DB that should be synchronized becuase of some reasons)...
At snapshot definition I just set each table to Truncate All rows at initialization level. But the problem was that it drop all indeces automatically and FK Constrains which causes the different schema in subscriber DB. So I dcided to set to Copy ALL of
related objects (indeces,FKs,cluster indeces,triggers ,...) at initialization level. But the problem is with 5 tables that are not published when all their relations with the other 10 tables will be droped at initialization level....Beside of all these problems
I get FK constraint error at initialization time...
Also I should mentioned that my DB version is 2000 SP4.
Did I miss or misunderstood something? or should I choos another solution? or some problem in SQL 2000 and should migrate to 2005 or 2008?
Thanks for your appreciation