July 14, 2005 at 11:26 pm
Hi,
I am having two different servers located at different places. Those systems are having 2 different sort orders as below:
1. Server A -> sort order 42
2. Server B -> sort order 52
I am given a task to restore a backup copy with sort order 42 on to the second server with sort order 52. Before taking the backup, I haven't checked the sort order of that database.
Is there any possibility of restoring the database with sort order 42 to server with sort order 52. Both the servers are having SQL v7.0 installed on them.
Will appreciate for suggestions given.
Lucky
July 18, 2005 at 8:00 am
This was removed by the editor as SPAM
July 18, 2005 at 12:00 pm
It's a long time since I used 7.0 but I seem to remeber it works the same as 2k and will restore the database with the original sort order ( retained in the database )- what impact that will have on the database and the apps is another matter of course!
To actually chnage the sort order of a database requires you to transfer the objects and data to a new database created with the required sort order, as far as I remember ( long time ago someone built a server with wrong sort order for me )
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply