Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

disconnect from data

Discussion in 'Information Technology' started by hugh welford, Jul 28, 2006.

  1. hugh welford

    hugh welford
    Expand Collapse
    Guest

    Hi, I'm trying to do an on-the-fly data backup/copy to the C; drive from
    the server on closing down the application, by using filecopy command.

    Filecopy will not work while the data file is open. Is it possible to
    disconnect from the data by code so that I can copy the data before the
    application closes down?

    Thanks

    Hugh
     
  2. Loading...


  3. Sheila D

    Sheila D
    Expand Collapse
    Guest

    I don't know but maybe you could approach it differently and use the
    TransferDatabase command?

    "hugh welford" wrote:

    > Hi, I'm trying to do an on-the-fly data backup/copy to the C; drive from
    > the server on closing down the application, by using filecopy command.
    >
    > Filecopy will not work while the data file is open. Is it possible to
    > disconnect from the data by code so that I can copy the data before the
    > application closes down?
    >
    > Thanks
    >
    > Hugh
    >
    >
    >
    >
     
  4. hugh welford

    hugh welford
    Expand Collapse
    Guest

    Thanks Sheila - you learn something every day!! Will give it a try

    Hugh


    "Sheila D" <SheilaD@discussions.microsoft.com> wrote in message
    news:9C21FAB9-157B-4687-A988-7B069DDD65E8@microsoft.com...
    >I don't know but maybe you could approach it differently and use the
    > TransferDatabase command?
    >
    > "hugh welford" wrote:
    >
    >> Hi, I'm trying to do an on-the-fly data backup/copy to the C; drive from
    >> the server on closing down the application, by using filecopy command.
    >>
    >> Filecopy will not work while the data file is open. Is it possible to
    >> disconnect from the data by code so that I can copy the data before the
    >> application closes down?
    >>
    >> Thanks
    >>
    >> Hugh
    >>
    >>
    >>
    >>
     

Share This Page