Viewing 15 posts - 76 through 90 (of 115 total)
sort of. Alternate sync partners are standby merge replication publishers which the subscriber can sync with for short amounts of time before the original publisher comes back online. The subscriber...
July 27, 2005 at 4:32 am
a is wrong, it should read right click on your database, select properties, in the option tab select full. Using Enterprise Manager, right-click the database and modify the property on...
July 15, 2005 at 5:23 am
have a look at data compare for redgate - this product does this.
also check this out
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on...
July 1, 2005 at 4:38 am
You can use both - IIRC there could be licensing problems if there is no SQL Server in the mix; from what I recall you can use EM if MSDE...
June 28, 2005 at 4:45 am
you are correct - this is the way to do this.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
June 28, 2005 at 4:42 am
We replicate to our dmz all the time. On the internet facing side our firewall will not allow inbound connections, on the lan side it will. We can connect to...
June 9, 2005 at 4:27 am
create another job step for your agent. Have step 3 go to this job on failure. Have this job raise a custom event which logs to the event log. You...
June 8, 2005 at 5:08 am
He's wrong. It can be in any mode. I think he is making this recommendation to maintain the size of the log file.
Ideally you want the log file to...
June 7, 2005 at 3:55 am
The question you should be asking yourself is what do you want high availability or a disaster recovery solution.
If you are interested in high availability - or short downtimes and...
May 24, 2005 at 5:43 am
save them in the file system. Extract the textual content from them (use FiltDump -b to do this), and store the textual content in the database. Index the data in...
May 20, 2005 at 4:36 am
it can't be done. In sql 7, 2000, and 2005 near is defined as words withing 1362 (IIRC) words. Any more distance and this row won't be returned in your...
May 12, 2005 at 4:53 am
the best way to do this is either by using bi-directional transactional replication or merge replication. To start for bi-directional transactional replication you will need to restore the publication database...
April 14, 2005 at 4:58 am
by default replication will delete all the data in the row, whether it came from replication or the import process. You could create a filter if there was something about...
April 14, 2005 at 4:56 am
There is no difference between having one publication or multiple publications - there is no extra over head, no advantages for replicating static tables in one publications, volatile tables in...
March 23, 2005 at 6:13 am
don't use a linked server, configure it as an ODBC subscriber - but SQL Server does not work with mysql - there is a bug.
--
Hilary Cotter
Looking for a SQL...
March 11, 2005 at 5:33 am
Viewing 15 posts - 76 through 90 (of 115 total)