How do I restore a .bak file into MSDE 2000

Posted on 2007-09-29
Last Modified: 2008-01-09
I have a database named graphics.bak from a SQL 2000 server. It is located on my c: in c:\test
What command would I use to restore this?

Question by:ainselyb
    LVL 51

    Expert Comment

    LVL 18

    Expert Comment

    This might work:

    restore database graphics
    from file c:\test\graphics.bak

    If some details are not the same on the previous server and this one, youmight run into an error.
    Just post it here, we'll help you out step by step ...

    Hope this helps ...
    LVL 14

    Accepted Solution

    you can use the EM to restore your backup DB...tht is more easier...or are you looking only for scripts


    RESTORE DATABASE nwind_new FROM DISK = 'c:\backups\northwind\nwind.bak'
    MOVE 'northwind' TO 'd:\Program Files\Microsoft SQL
    MOVE 'northwind_log' TO 'd:\Program Files\Microsoft SQL

    check this link its very helpful

    Author Comment

    Yveau - I did get an error

    The media family on device 'c:\lms_v5_1.bak' is incorrectly formed. SQL Server cannot process this media family.

    I can't find a work around??????????
    LVL 18

    Expert Comment

    ehm ... where does the file c:\lms_v5_1.bak suddenly come from ?
    I could understand if there where problems with the original path of the files, in that case the 'MOVE' clause had to be used, but this error is strange, since you tried to restore the file c:\test\graphics.bak ... right ?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now