restore mssql 7.0. database

When I try to restore mssql 7.0 database,I got strange error :

The database you are attempting to restore was backed up under a different sort order ID (52) than the one currently runing on the server (106), and at least one of them is a non-binary sort order.
Backup or restore operation terminating abnormally.

Is there a way how i can fix it ?
Thanks a lot !You need to change sort order by using REBUILDM utility to rebuild the master database, refer to books online for more information.

Or rebuild the target server with source server's collation settings.

Restore MB/Sec

What sort of MB/Sec do you have for a restore operation?
I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the
log, and the backup is coming from a 6 Disk RAID10 array.. ..the database I
just restored reported "RESTORE DATABASE successfully processed 14937911
pages in 5809.377 seconds (21.064 MB/sec).", from perfmon I can see the
database I am restoring now is experiencing average sec/write of 0.08 -
0.10, and has a throughput of around 40/50MB.. ..I thought it would be a bit
better than this and just wanted to benchmark this against other
observations...
(Currently nothing else is occuring on the box apart from the restore)"Ben UK" <BenUK@.discussions.microsoft.com> wrote in message
news:91DF00F5-6938-41BD-928E-5942F3CB88E6@.microsoft.com...
> What sort of MB/Sec do you have for a restore operation?
> I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the
> log, and the backup is coming from a 6 Disk RAID10 array.. ..the database
> I
> just restored reported "RESTORE DATABASE successfully processed 14937911
> pages in 5809.377 seconds (21.064 MB/sec).", from perfmon I can see the
> database I am restoring now is experiencing average sec/write of 0.08 -
> 0.10, and has a throughput of around 40/50MB.. ..I thought it would be a
> bit
> better than this and just wanted to benchmark this against other
> observations...
Hard to say.
I know when I did some testing on our servers, the limiting factor was the
source drives.
(btw, 15 disk RAID 10, I have to assume one is a hot spare, since otherwise
that doesn't work).
Also, you could be hitting network limitations.
> (Currently nothing else is occuring on the box apart from the restore)
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

Restore MB/Sec

What sort of MB/Sec do you have for a restore operation?
I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the
log, and the backup is coming from a 6 Disk RAID10 array.. ..the database I
just restored reported "RESTORE DATABASE successfully processed 14937911
pages in 5809.377 seconds (21.064 MB/sec).", from perfmon I can see the
database I am restoring now is experiencing average sec/write of 0.08 -
0.10, and has a throughput of around 40/50MB.. ..I thought it would be a bit
better than this and just wanted to benchmark this against other
observations...
(Currently nothing else is occuring on the box apart from the restore)"Ben UK" <BenUK@.discussions.microsoft.com> wrote in message
news:91DF00F5-6938-41BD-928E-5942F3CB88E6@.microsoft.com...
> What sort of MB/Sec do you have for a restore operation?
> I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the
> log, and the backup is coming from a 6 Disk RAID10 array.. ..the database
> I
> just restored reported "RESTORE DATABASE successfully processed 14937911
> pages in 5809.377 seconds (21.064 MB/sec).", from perfmon I can see the
> database I am restoring now is experiencing average sec/write of 0.08 -
> 0.10, and has a throughput of around 40/50MB.. ..I thought it would be a
> bit
> better than this and just wanted to benchmark this against other
> observations...
Hard to say.
I know when I did some testing on our servers, the limiting factor was the
source drives.
(btw, 15 disk RAID 10, I have to assume one is a hot spare, since otherwise
that doesn't work).
Also, you could be hitting network limitations.

> (Currently nothing else is occuring on the box apart from the restore)
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com