Post reply

Database backup with 3 log files need to restore to another server.

  • July 23, 2014 at 11:40 am

    #288198

    Hi all,

    I have a DATABASE on server A, which has 2 data file and 2 log files ( plz don't ask why). Now for I need to take a full backup of the database on Server A and Restore on Server B.

    Now I like to restore the database with only 1 data file and 1 log file on Server B. How Can I do that?

  • July 23, 2014 at 11:52 am

    #1731886

    You can't delete or eliminate particular database file during restore operation.Once the database has been restored to your destination, you can empty the extra 2nd log file and then remove it permanently.

  • July 23, 2014 at 12:06 pm

    #1731891

    salute to you sir!!!

  • July 23, 2014 at 12:11 pm

    #1731894

    A better option is to drop the second log file on the source database before you backup the database.

    A second log file is pretty pointless except in the case where you had to add it in an emergency.

    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

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

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