Windows 2008 server and datafiles

Juan Bofill bofill at
Mon Dec 6 07:23:47 EST 2010

How about disk caches? Can you turn them Off or On as in 2003 Server? 

Juan Bofill

On 03-12-10, at 01:04, Kim Sumner wrote:

> Hi Derek
> We had a similar problem at a site where the data file corrupted every few
> weeks. Invariably the database needed to be recovered and the errors always
> referred to problems with block allocation. My hunch is that the server
> environment (in this case a VM installation of W2003 Server) is somehow
> interfering with O7 trying to resize the segments.
> I've recently tested my theory by manually growing the data file well in
> excess of their likely usage. I've twice checked the production ODF since
> this was done and so far no problems. I intend to repeat integrity tests
> after 3 months deployment to see whether this strategy has made any
> difference.
> (Note: We have an identical O7 site that's not virtualised and it has
> _never_ experienced any corruption problems. Hence my suspicions. Both sites
> have been in production using our software for over 10 years and corruption
> only emerged when one site moved to W2003 Server).
> Kim Sumner
> Corporate Windows Pty Ltd, AUSTRALIA
> WebPublisher Studio - Share your data with the World
> Omnis Studio Database Server Integration Toolkit
>> From: Derek Delpero <derek.delpero at>
>> Reply-To: OmnisDev List - English <omnisdev-en at>
>> Date: Wed, 1 Dec 2010 15:52:21 -0600
>> To: <omnisdev-en at>
>> Subject: Windows 2008 server and datafiles
>> Hi,
>> We have some sites that recently upgrade their servers to Windows
>> 2008. The app is Omnis7 with a multi-user data file. They've been
>> running pretty solid for years, and since the upgrade they've been
>> having a lot of data corruption issues with indexes and duplicated
>> rsns.
>> We looked at disabling opportunistic locking but according to this
>> Microsoft kb article (, it's
>> not possible to disable opportunistic locking in Windows 2008.
>> Does anyone know if disabling SMB2 is the only option? Any
>> disadvantages of disabling SMB2?
>> Thanks,
>> Derek
>> _____________________________________________________________
>> Manage your list subscriptions at
> _____________________________________________________________
> Manage your list subscriptions at

More information about the omnisdev-en mailing list