Ntbackup "file is in use"

Posted on 2005-04-28
Last Modified: 2010-05-18

Is there anyway I can get NTbackup to copy an access database that is curretnly open?  This is done in the middle of the night so it isn't actually in use it is just that someone has left it open.  I can use a xcopy but would rather use ntbackup.  As the file is not being used is there some way of using net file /close to automatically close the file (don't want to use restart as an alternative)?

Question by:WannabeNerd
    LVL 15

    Expert Comment

    I wouldn't force the file closed - it's an access database, and they are easily corrupted.

    Why not enforce logon restricitons - kick the users off before the backup and don't let them on till it finishes.


    Author Comment

    thats an idea.  I know how to enforce logon restrictiopns but have'nt used them before.  Does the user actually get logged off if they are already logged on when they hit a period where they are not allowed to be logged on?
    LVL 10

    Accepted Solution

    You must be logged in as the user account that NTbackup runs under..

    Change the following reg key, to enable NTbackup to backup files in use..

    HKEY_CURRENT_USER\Software\Ntbackup\Backup Engine\Backup Files inUse

    Change REG_SZ from 0 to 1

    0 - Backup skips open files
    1 - Backup includes open files
    LVL 15

    Expert Comment

    You can set the logon period policy to either not let users on when it's out of hours, or to not let them on *and* log off anyone who is out of hours.

    In Group Policy Editor - Windows Settings > Security Settings > Local Policies > Security Options > Force Logoff when logon hours expire (in W2k3 it's got a prefix of "Network Security:")

    Try Sean's suggestion, but I know even Backup Exec cannot backup files that are open for writing (such as your database, and SQL, Wins and DHCP databases) so I don't think it will work if the file is locked for writing. Then again - an access database can be opened by multiple users, so maybe it isn't locked in the same manner as a regular file (hence the .lck file?)...


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    Outlook Free & Paid Tools
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now