Post reply

Stored Procedure

  • April 27, 2008 at 8:20 pm

    #185790

    Hi, Can anybody help me to create store preocedure to do a restore?

    Four input patrameters

    1ST name of the database

    2nd Backuptype,

    3rd restore type,

    4tht Name of the restored database

    SHOULD MOVE TO A NEW PATH WITH A NEW NAME

    Thanks a lot

    Satinder

  • April 28, 2008 at 2:22 am

    #807639

    You might want to consider looking at the RESTORE command : http://msdn2.microsoft.com/en-us/library/ms186858.aspx

    You could wrap that in stored procedure logic if you wished.

    Simon

  • April 28, 2008 at 7:46 am

    #807763

    This really sounds like a very basic homework assignment. Post the code you have written so far and I'm sure someone could help you tweak it if needed.

    If you need the syntax for creating stored procs, BOL (books on line) is a good start.

    Marvin Dillard
    Senior Consultant
    Claraview Inc

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

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