Post reply

Restore

  • July 1, 2009 at 2:59 am

    #384890

    Hi Guru's

    Can anyone please tell me what are the prerequisites for restoring the database..

    Thanks in Advance..

  • July 1, 2009 at 4:47 am

    #1018267

    you should have a backup to restore 😀

    and that should be valid ..

    Please ask what you want to know ...this was a closed ended question .

    I am not sure how to answer that and many others will be in the same soup.

    ask specific questions and we will be glad to answer my friend ..

    Regards

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

  • July 1, 2009 at 7:36 am

    #1018392

    Pretty much, you have to have a valid backup, the privileges on the server, and enough space to support the backup. That's about it. What were you looking for?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 1, 2009 at 7:40 am

    #1018400

    and yes, you should also have a login id and password to login to the target server with appropriate rights.:-P

    Edit :- Oops, Grant already mentioned abt privilages...:hehe:


    Pradeep Singh

  • July 1, 2009 at 7:50 am

    #1018408

    Sure that you should have backup valid file (if you test the restoring these db when you take the backup)!

    And also some other things like "Overwrite the existing database", "Restore With Recovery", "Restore With NoRecovery" etc etc ...it depends from you Server infrastructure and the situations with your problem!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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