sql server programming: restore database through form i created -- sql server programming

restore database through form i created

Orange Kuik
11/28/2004 7:47:01 PM

sql server programming:

Hi,im using foxpro7+VPME7 and sqlserver as my database.i created a Store
Procedure to restore database from the backup file i backup in server. Im
trying to called the store procedure restore in the form(application) to
restore the database to the database i login in the system, but its failed to
restore! Its sucessfull restore only when i restore to another database
name..Any ways can work to restore my database to the database i log in??

RE: restore database through form i created

Huiyong Lau
11/28/2004 8:31:01 PM

Nope. Database restore need exclusive access on the database to be restored.
Try change the database context to tempdb before running the database
restore.

HTH,
Huiyong

[quoted text, click to view]

RE: restore database through form i created

Orange Kuik
11/28/2004 9:05:02 PM

Thanks ur advice...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.