Post reply

steps to restore database

  • March 30, 2017 at 3:29 am

    #329002

    Hi Team,

    I'm trying to restore a database on sql2008 environment. I have the full backup.

    can u please let me know the steps required before the start of this

    Thanks

  • March 30, 2017 at 3:51 am

    #1935660

    If you Google this or look in Books Online you will find all the steps to restore a database.

    Thanks

  • March 30, 2017 at 3:57 am

    #1935661

    (1) Type "restore a database on sql2008 environment" into your favourite search engine
    (2) Click on some of the ensuing links and read through them
    (3) Follow the steps in the one you feel most comfortable with.  Do this in a test environment if this is your very first time
    (4) Post back here if there's anything in particular that you don't understand

    The only thing I would add to my somewhat generic advice above is to recommend that you take the extra few minutes to use the T-SQL commands instead of the GUI.  You'll end up saving time in the long run, because your scripts will be reusable, especially in the (almost inevitable for a beginner) event that your first attempt fails and you have to start again.

    Good luck
    John

  • March 30, 2017 at 11:10 am

    #1935781


    RESTORE DATABASE YourDB FROM DISK='Path to backup here'

    If you want to overwrite an existing database

    WITH REPLACE

    If you need to move files

    , MOVE 'logical file name' TO 'New path here'

    If you want to see progress at 10% intervals

    , STATS = 10

  • March 30, 2017 at 11:28 am

    #1935786

    atulyan.aries - Thursday, March 30, 2017 3:29 AM

    Hi Team,

    I'm trying to restore a database on sql2008 environment. I have the full backup.

    can u please let me know the steps required before the start of this

    Thanks

    Where is it that you are stuck?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 31, 2017 at 2:12 am

    #1935920

    Doa search right here in SQL Server Central. There are articles on restore all over the place, detailing different options and methods, pretty much everything you'd need.

    "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

  • April 4, 2017 at 11:28 pm

    This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

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