Post reply

rollback database after restore backup sql2000

  • June 13, 2009 at 5:52 am

    #205468

    hello

    i need help if i can retrieve data after i restore it from backup.

    i need to get old data ?

    thanks

  • June 13, 2009 at 6:20 am

    #1009058

    ahmedzakey1983 (6/13/2009)

    hello

    i need help if i can retrieve data after i restore it from backup.

    i need to get old data ?

    thanks

    If you are restoring a database from a backup file, you will definitely get the data what was present when you backed up your database(provided your backup file is not corrupt). If you do not want to mess up with existing database, i suggest u to restore it to some other database and move the .mdf and .ldf to new location (WITH MOVE=)

    Complete syntax of Restoration is here:

    http://msdn.microsoft.com/en-us/library/ms186858.aspx


    Pradeep Singh

  • June 13, 2009 at 6:25 am

    #1009059

    you posted the problem in an incorrect forum(2005).

    also, from the title of the thread, it seems you want to restore the database to a prior state. in such case you may want use(with replace) clause. Make sure all active users are disconnected before you begin restoration.

    For SQL 2000, the link for restore is

    http://msdn.microsoft.com/en-us/library/aa238405.aspx


    Pradeep Singh

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

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