Post reply

Cancel the restore process of database and maintain the original stete of database using SQLDMO

  • September 21, 2006 at 3:42 am

    #94370

    Hi All!

    i am doing a C# application in which i need to Restore a database from a .bak file from my logical drives.I am able to restore the database sucessfully but what i need is the functionality to cancel the Restore process and after canceling the process i need to maintain the original state of the database.I am using SQLDMO to restore the database. Please give me some code snippet so that i can can the Restore process by clicking the cancel button and also maintaining the original state of the database.

    Regards,

    Ajit

  • September 25, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • September 25, 2006 at 2:19 pm

    #662366

    It cannot be done via native SQL and QA. If you cannot do it from QA then you cannot do it from C#.  However, you may consider restoring to an alternative database name and then dropping the old database and renaming the restored database to the name desired.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply