restore from script file

  • I have generated script file from database1 as "database1.sql file" and want to restore database 2.

    How can i do?

    Plz,guide me step by step

  • Open the script and run it against database2.

  • Open in management studio, change the database name (if necessary) and execute.

    You are aware that this is just a script of the structure of the DB? There's no data included in the script.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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