Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling SQL SERVER backup & restore fro VFP
Message
From
09/07/2006 13:02:20
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
07/07/2006 15:35:09
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01134436
Message ID:
01134791
Views:
21
>Ok the backup works ! Thanks ! Now I am trying to do the restore but it tells me that the database is in use, so I tried an SQLDISCONNECT() then SQLEXEC() to run the restore but I know longer have a connection handle to send with the SQLEXEC(). Is there anyway to attach to the database without actually opening it ?

Add a "use master" line before the first line of your restore command, and don't disconnect. You can't restore a database while you're using it - so use master instead. It has to do some housekeeping (to register the restore, at least) anyway.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform