<div>
Sorry with backuping you can't doit unless you use different sort orders, if your computers are connected via Network you can use, DataBase Transfer<br />

</div>


Sorry with backuping you can't doit unless you use different sort orders, if your computers are connected via Network you can use, DataBase Transfer


<div>
Sorry I've wanted it like comment<br />

</div>


<div>
If I transfer it via network,How can I do?<br />
If I use a diskette to copy it,How can I do?<br />
Can you tell me detailedly?<br />

</div>


If I transfer it via network,How can I do?
If I use a diskette to copy it,How can I do?
Can you tell me detailedly?


<div>
Did you close the database before trying to backup?<br />
What Database is it?<br />

</div>


Did you close the database before trying to backup?
What Database is it?


<div>
<div class="content wysiwyg-content">
I want to copy a database from one computer to another computer,I use Database Backup/Restore tool to backup it &nbsp;to a diskette, in another computer I use Database Backup/Restore tool to restore it,but it displays the following error:<br />
&quot;The database you are attempting to load was dumped under a different sort order ID(199) than the one currently running on this server and at least one of them is a non-binary sort order.&quot;<br />
How can I do that?<br />
<br />

</div>
</div>


I want to copy a database from one computer to another computer,I use Database Backup/Restore tool to backup it  to a diskette, in another computer I use Database Backup/Restore tool to restore it,but it displays the following error:
"The database you are attempting to load was dumped under a different sort order ID(199) than the one currently running on this server and at least one of them is a non-binary sort order."
How can I do that?



how to copy a database from one computer to another?

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.