<div>
here's another solution:<br />
<br />
Create the database you want. Ex: MyDb<br />
<br />
then stop your SQLSERVER<br />
<br />
move the mydb.mdf and mydb.ldf in your data directory to a temp directory.<br />
<br />
Take your &quot;original&quot; mydb.mdf and mydb.ldf and copy them in your data directory<br />
<br />
Restart your SQLSERVER<br />
<br />
<br />
I know it might not be the better solution, but it saved me once...<br />
<br />

</div>


here's another solution:

Create the database you want. Ex: MyDb

then stop your SQLSERVER

move the mydb.mdf and mydb.ldf in your data directory to a temp directory.

Take your "original" mydb.mdf and mydb.ldf and copy them in your data directory

Restart your SQLSERVER


I know it might not be the better solution, but it saved me once...



<div>
Hi again!<br />
<br />
I did as adathelad said and it worked fine. Thanx for the support. You have saved my day!<br />
<br />
Andreas<br />
<br />

</div>


Hi again!

I did as adathelad said and it worked fine. Thanx for the support. You have saved my day!

Andreas



<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
I wonder if its possible to restore a databas if I only have the *.mdf and *.ldf file in Microsoft SQL 7.0. If I'm using the *.bck file I will lose a month of work...<br />
<br />
Thanks!<br />
Andreas
</div>
</div>


Hi!

I wonder if its possible to restore a databas if I only have the *.mdf and *.ldf file in Microsoft SQL 7.0. If I'm using the *.bck file I will lose a month of work...

Thanks!
Andreas

SQL 7.0 Restore with only *.mdf and *.ldf

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.