<div>
Instead of doing a backup and restore you need to<br />
use a dts package to transfer the data from one database to annother<br />
Using the Import data command from sql server 2003. <br />
<br />
Jay <br />
<br />

</div>


Instead of doing a backup and restore you need to
use a dts package to transfer the data from one database to annother
Using the Import data command from sql server 2003.

Jay



<div>
How are you trying to &quot;open&quot; the MDf in SQL2000? &nbsp;Sp_attach_db?
</div>


How are you trying to "open" the MDf in SQL2000?  Sp_attach_db?

<div>
<div class="content wysiwyg-content">
I have a mdf file: GestioneEventi.mdf created by SQL Server 7.0. Now I'm trying to open this file on SQL Server 2003 but the installation fails and this is the message that appears:'Error 1813 - Could not open new database 'GestioneEventi'. CREATE DATABASE is aborted.<br />
Device activation error. The physical file name 'C:\Programmi\Microsoft SQL Server\MSSQL\data\Gestione<wbr />Enti_Log.L<wbr />DF' may be incorrect.'<br />
<br />
If I try to use the old GestioneEnti.ldf &nbsp;this is the message that I receive from the server: 'Error 5173 - Could not associate files with different databases' ( I've tried to open this file on SQL Server 2000 whith the same results).<br />
<br />
What's the problem? How I can resolve this problem? Thanks
</div>
</div>


I have a mdf file: GestioneEventi.mdf created by SQL Server 7.0. Now I'm trying to open this file on SQL Server 2003 but the installation fails and this is the message that appears:'Error 1813 - Could not open new database 'GestioneEventi'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:\Programmi\Microsoft SQL Server\MSSQL\data\GestioneEnti_Log.LDF' may be incorrect.'

If I try to use the old GestioneEnti.ldf  this is the message that I receive from the server: 'Error 5173 - Could not associate files with different databases' ( I've tried to open this file on SQL Server 2000 whith the same results).

What's the problem? How I can resolve this problem? Thanks

Problems to open an mdf file on SQL Server 2003

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.