Restore of 6.5 master.dat to a different 6.5 server fails

[tjohnsb]

I am trying to set-up a test server(ServerB) to mirror my production server (ServerA). I have set-up ServerB with all of the same databases and devices that are on ServerA. When I restore the master.dat file from a back-up on ServerB I receive several error messages refering to database devices being the wrong size and in the wrong location. The device paths for ServerA and ServerB are the same but the server names are different. Do the server names need to be the same? Do the devices have to be exactly the same size? Any guidance about the procedure of restoring a SQL Server 6.5 master.dat on a different server running SQl Server 6.5 would be greatly appreciated. Thank you.

 

[tlbroadbent]

The device size and structure, number and size of extents, must be identical as I recall. Neil Pike published some good directions for moving a 6.5 database in the SQL FAQ.

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14346

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.