Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP v SQL for large database applications
Message
From
20/04/2007 10:34:11
 
 
To
20/04/2007 10:19:29
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01218204
Message ID:
01218283
Views:
22
>>>You cannot really backup live (open tables)
>>
>>I never even tought of that ;
>>
>>However, I am able to copy entire database to local PC folder at any time
>>with all my users logged in.
>>Does it mean MS Backup is more demanding as to have exclusive grip
>>on data then ordinary copy call ?
>>
>>I am doing that from time when I need to troubleshot something on a snapshot of live data. Theoretically, that means that I could schedule (x)copying of entire set of folders to alternative location and then then perform backup from there even if my users were loged 24/7 ?

>
>Well, a DBF is a Windows file, not a real database. So if there is an Exclusive lock it is reflected in Windows OS, which may prevent a backup program for working with that file.

That yes, but if someone uses optimistic table buffering troughout/without exceptions, then even MS backup might work or I am mistaken ?
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform