Solved

sort code id

Posted on 2003-10-31
3
192 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 250 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now