Hi Peep's
i have a problem when trying to restore a backup file that ive taken off from a backup server. Im now trying to restore the database from this .bak file, but when i try to do so it throws up an error message saying that the backup was done so under sort order id 54 where as the SQL Server 7 that im running on a different server is running in sort order id 52 (apparently!)
ive tried to re-install the SQL server a couple of times, but nowhere have i come across an option to change the sort order (even in custom install)
any help would be great as its hurting me every minute i look at my screen! and i think my hair might fall out if i pull it any more.....
thank you
i have a problem when trying to restore a backup file that ive taken off from a backup server. Im now trying to restore the database from this .bak file, but when i try to do so it throws up an error message saying that the backup was done so under sort order id 54 where as the SQL Server 7 that im running on a different server is running in sort order id 52 (apparently!)
ive tried to re-install the SQL server a couple of times, but nowhere have i come across an option to change the sort order (even in custom install)
any help would be great as its hurting me every minute i look at my screen! and i think my hair might fall out if i pull it any more.....
thank you