Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sort code id

Posted on 2003-10-31
3
Medium Priority
?
208 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

636 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