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:19:29
 
 
To
20/04/2007 10:02:45
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:
01218279
Views:
25
>>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.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform