<div>
You have to do it on the command line: <a href="http://metrix.fcny.org/wiki/display/dev/Using+OSQL+to+backup+and+restore+a+database" rel="ugc">http://metrix.fcny.org/wiki/display/dev/Using+OSQL+to+backup+and+restore+a+database</a>
</div>


You have to do it on the command line: http://metrix.fcny.org/wiki/display/dev/Using+OSQL+to+backup+and+restore+a+database [http://metrix.fcny.org/wiki/display/dev/Using+OSQL+to+backup+and+restore+a+database]

<div>
This might work:<br />
<br />
restore database graphics<br />
from file c:\test\graphics.bak<br />
<br />
If some details are not the same on the previous server and this one, youmight run into an error.<br />
Just post it here, we'll help you out step by step ...<br />
<br />
Hope this helps ...<br />

</div>


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 ...


<div>
Yveau - I did get an error <br />
<br />
The media family on device 'c:\lms_v5_1.bak' is incorrectly formed. SQL Server cannot process this media family.<br />
<br />
I can't find a work around??????????<br />

</div>


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??????????


<div>
ehm ... where does the file c:\lms_v5_1.bak suddenly come from ?<br />
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 ?<br />

</div>


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 ?


<div>
<div class="content wysiwyg-content">
I have a database named graphics.bak from a SQL 2000 server. It is located on my c: in c:\test<br />
What command would I use to restore this?<br />
<br />

</div>
</div>


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?



How do I restore a .bak file into MSDE 2000

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.