Frequency of compressing/repair replicated databases

Bob Alston

I have a system built using Access replication. After some initial
problems dealing with memo fields, it now seems to be working well.

I am curious as to how frequently others Compress & Repair replicated
databases?

Bob

Oct 7 '08 #1

Subscribe Reply

2607

David W. Fenton

Bob Alston <bo********@yah oo.comwrote in
news:Hr******** ********@newsfe 08.iad:

I have a system built using Access replication. After some
initial problems dealing with memo fields, it now seems to be
working well.

I am curious as to how frequently others Compress & Repair
replicated databases?

First off, is your app split, with your data tables in one MDB that
is replicated, and all your forms/reports/etc. in a separate MDB
that is *not* replicated? If not, that's much more important to fix
than worrying about how often you compact.

Compacting a replicated database is a bit more dangerous than
compacting non-replicated databases. This is because certain minor
corruptions that are easily repaired by a compact in a
non-replicated database cause a replicated MDB to lose replicability
(which means it can't synch with the other members of its replica
set any longer). Unfortunately, there's no way to tell if you have
this kind of problem -- it is only revealed after the fact, when
replicability is lost.

Thus, I'd recommend regular maintenance compacts on a replicated
back end at a lower frequency than on a non-replicated back end. If
you're compacting your non-replicated MDB every day, I'd recommend
every week for a replicated MDB. Keep in mind that the other
replicas in teh replica set function as backups, so you're not in as
much danger of data loss as you are with a single non-replicated
MDB. And if you implement a replica farm, you can have very good
coverage in terms of recovery from the loss of any single replica.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Oct 8 '08 #2

Bob Alston

David W. Fenton wrote:

Bob Alston <bo********@yah oo.comwrote in
news:Hr******** ********@newsfe 08.iad:

>I have a system built using Access replication. After some
initial problems dealing with memo fields, it now seems to be
working well.

I am curious as to how frequently others Compress & Repair
replicated databases?

First off, is your app split, with your data tables in one MDB that
is replicated, and all your forms/reports/etc. in a separate MDB
that is *not* replicated? If not, that's much more important to fix
than worrying about how often you compact.

Compacting a replicated database is a bit more dangerous than
compacting non-replicated databases. This is because certain minor
corruptions that are easily repaired by a compact in a
non-replicated database cause a replicated MDB to lose replicability
(which means it can't synch with the other members of its replica
set any longer). Unfortunately, there's no way to tell if you have
this kind of problem -- it is only revealed after the fact, when
replicability is lost.

Thus, I'd recommend regular maintenance compacts on a replicated
back end at a lower frequency than on a non-replicated back end. If
you're compacting your non-replicated MDB every day, I'd recommend
every week for a replicated MDB. Keep in mind that the other
replicas in teh replica set function as backups, so you're not in as
much danger of data loss as you are with a single non-replicated
MDB. And if you implement a replica farm, you can have very good
coverage in terms of recovery from the loss of any single replica.

Thanks for the suggestions. Yes I do have a separated FE and BE. Of
course I only replicate the BE.

Recently I compressed and repaired the three sets of replicas in farms
on each of three servers. It reduced their size considerably.

I am concerned about the replicas on the laptops where I have no
schedule for compress and repair.

I trhink I recall once hearing about someone creating a second replica
on a laptop as a backup. I wonder if that would be something to do just
before doing the compress/repair in case I lost ability to replicate.
YOur thoughts?

Bob

Oct 8 '08 #3

David W. Fenton

Bob Alston <bo********@yah oo.comwrote in
news:V%******** ******@newsfe04 .iad:

I am concerned about the replicas on the laptops where I have no
schedule for compress and repair.

Chances are good that this is not going to matter a lot.

I trhink I recall once hearing about someone creating a second
replica on a laptop as a backup. I wonder if that would be
something to do just before doing the compress/repair in case I
lost ability to replicate. YOur thoughts?

Most of my replicated apps do a synch with a backup replica upon
closing as a matter of course.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Oct 9 '08 #4

Similar topics

1883

SocketPro -- A framework implemented on batching/queue, asynchrony and parallel computaion with online compressing

by: Yuancai \(Charlie\) Ye | last post by:

Hi, All: I am happy to annouce that we have formally released our latest SocketPro version 4 at www.udaparts.com, an advanced remoting framework written from batching/queue, asynchrony and parallel computation. Key Benefits of SocketPro: Super performance and scalability It is a guarantee that SocketPro based client-server applications

.NET Framework

2998

Automate compact and repair/backup database

by: Andy Davis | last post by:

Is it possible to create a button with code to carry out the a weekly compact and repair of database and backup? My users know how to do this from the menu but would really like some kind process where they are reminded to do it and then just click the button to do so. Any tips on the best way forward would be much appreciated. Thanks in advance Dawn Davis

Microsoft Access / VBA

4957

/repair from a .bat file - access 97

by: ritenah | last post by:

I am running this command from a .bat file. "C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR Database repairs as expected, then shows the messge: "Successfully repaired the ..." and you have to click "Ok" to get rid of the message so that the database can close. How does one suppress this message, so that the database shuts down

Microsoft Access / VBA

2779

Problem with Compact/Repair

by: Ron | last post by:

Hi All, Using WinXP pro/Access 2000. I have a database that's been used for about 5 months. Transferred lots of data from a dos based program, then the users have been using it for that 5 months. About 180000 records in one of the main files (maybe 25000 new since the dos conversion). Been having some speed issues crop up along the way (much faster to do same reports when I first transferred the data than now, with the new 25000...

Microsoft Access / VBA

1711

Design changes to a replicated database

by: aine_canby | last post by:

Hi, My company has an old access database which has been in use for many years now by a few employees. I need to make some design changes to one of the forms, but I'm not sure how I should go about doing this. I have designed databases with access before, but not when replication was used. So, should I first get everyone out of the database, then make a copy of the database to which I will add my changes to. Then finally,

Microsoft Access / VBA

1018

REPLICATED SERVERS Index FT Data differently.... WHY?

by: garrettm | last post by:

I've got 2 SQL server 2000 machined synched up using replication and there are full text catalogs running on 2 of the tables. the tables have the same number of records (as they're replicated) and when I freshly build the Full Text Catalogs on both the servers and run the same query against both the databases utilizing the Full Text Indexes... I get a different number of results returned. :-( why would the number of records vary between...

Microsoft SQL Server

2201

Records in Access corrupting and Compact/Repair function not able to resolve this.

by: Bizmark | last post by:

Access2003, Windows XP Pro OEM user OS, Windows Sever 2000 server OS. Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL server, but mainting these databases is critical to keeping the business running. 1 database in particular has been causing problems. Along the course we have had a few problems with random records corrupting (new and old) and Values within fields...

Microsoft Access / VBA

2733

How often to automatically compact & repair a replicated database

by: Bob Alston | last post by:

For those of you that have replicated databases, how often to you compact and repair them? Also what mathod do you use if you do this on an automated way? How do you make sure that the automated process is successful and if not, what process of notification is used? Bob

Microsoft Access / VBA

4555

Replicated Application MS Access database - how to undo

by: Eric L | last post by:

A client has a split database. However, the frontend is replicated. Since both frontend databases(replicated + DM)are both on same network drive, we would like to remove the replication of the front end. Can we just delete one of them and point the shortcut to open the other? *** Sent via Developersdex http://www.developersdex.com ***

Microsoft Access / VBA

8382

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8893

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8586

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7405

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6209

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5682

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4206

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4384

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1787

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General