?
Solved

sort code id

Posted on 2003-10-31
3
Medium Priority
?
210 Views
Last Modified: 2006-11-17
Am trying to restore a backup created on another sql 6.5 server . When i restore on my instance ,it give error like original backup created with sort code 54 , you are using 52
how do i resolve ?
0
Comment
Question by:mdwsamson
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 750 total points
ID: 9658160
The backup MUST be restored to a server that has the SAME sort code....
0
 

Author Comment

by:mdwsamson
ID: 9662552
How do i change the Sort Code On SQL 6.5
0
 
LVL 34

Expert Comment

by:arbert
ID: 9663489
It's not an easy task you'll have to rebuild the databases and reload the data.  That's why they tell you to choose the settings wisely when you install....
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

589 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