Home Forums SQL Server 2005 Backups Restoring database from production to Dev RE: Restoring database from production to Dev

  • Tripz (3/14/2013)


    To avoid all the confusions and complications

    I created a fresh db on dev and restored the backup to this freshly created db.

    and now things seems to be clean and now the dev website is pointing to new dev db and seems to be fine now.

    But - I am still not sure how to delete the extra ldf files in the backup file restore to db which has only one mdf and one ldf

    what did you do with the original dev db?

    The restore would remove the extra .ldf file for you.

    ---------------------------------------------------------------------