Create DB with backup file

  • Hello!

    I dont' have much experience working with SQL Server. I am working with a ASP .NET application and my company's partner sent me a test database. He sent the test database on a .BAK extension.

    1. Is it possible to load this backup on a already existing DB?

    2. If not, how do I create a new DB based on this backup file?

     

    Thank you.

    José Ferreira

  • #1.  Yes but all the information in that DB will be GONE

    #2.  Research Backup/Restore DB in BOL (Books on-line)



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • The easiest thing to do would be to create a new database using enterprise manager - and then use the restore database wizard to restore your .bak file to the newly created database - the wizards literally walk you through the steps - quickest way of learning the ropes...(imo)







    **ASCII stupid question, get a stupid ANSI !!!**

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

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