March 7, 2005 at 10:29 am
what woudl be the easiest way to make a copy of a database on a SQL server 6.5 to another SQL server 6.5 server?
i knwo i can go into C:\mssql\data and grab the data file but once i get that file onto the new machine, is there a way to import it using enterprise manager?
March 8, 2005 at 6:08 am
hi
The best way would be to do backup ,copy over the backup file to the new server and then restore it.but bear in mind that you would have to create the devices first.
Thanks
Ayo
March 8, 2005 at 8:18 am
ok - can someone direct me to a good tutorial on backups/restores in SQL server 6.5? i work with SQL server 2000 and unfortunately have been asked to move this old database and i dotn know much about 6.5.
March 8, 2005 at 9:09 am
Books Online should be installed on your v6.5 server.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 9, 2005 at 9:39 am
ok - so i was able to create the backup from serverA. i copied the backup file (.dat) from serverA to server B and tried to do a restore but when i tell it to restore from the file, i get the following error:
[SQL Server] The database you are attempting to LOAD was DUMPed under a different sort order ID [53] than the one currently running on this server [52] and at least one of them is a non-binary sort order.
anyone know what that means?
if anyone could help i would really appreciate it. i am just not familiar with sql 6.5 and my boss is on me to get this done.
March 9, 2005 at 9:55 am
The 'sort order' and/or 'character set' are different on the servers (in SQL v7.0 and SQL2000 they are collectively referred to as 'collations').
Try executing sp_helpsort on both servers. It will tell you the sort order and character set of each.
Also, examine the SQL Server errorlogs on both servers. As a part of the initial server startup you will see 'sort order' and 'character set' information. I do not have access to a v6.5 server (I'd have to install one at home).
In order to make a dump/load work, you'll have to rebuild the second SQL Server to match the first server where the dump came from. Short of this, the only option is to script the schema out then bcp over the tables one by one. This is how you get around the sort order thing. For character sets, well it all depends.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 9, 2005 at 9:59 am
hey thanks for the quick reply.
so if i rebuild the second server to match the sort order with that of the first, how do i actually specify the sort order - is there an option during setup whichallows me to set this?
according to the error message, the new servr is set to the default of 52 but the old server is set to 53.
March 9, 2005 at 10:03 am
Yep,
setup will prompt you for that!
* Noel
March 9, 2005 at 10:25 am
Be careful though, the prompt is in 'English' so to speak ... so be sure to jot down the 'sort order' and 'character set' from sp_helpsort.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply