• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1392
  • Last Modified:

Need to attach master database from another computer using MSDE

We are migrating a MSDE based application from one machine to another. But we are having problems trying to open the database in the new machine.

1. First we did a cold backup from the old machine. The application is mounted on a fork lift, so access to the machine is complicated. But we manage to gather all the mdf and ldf files. We didn't sp_dettach though.

2. We found out that the application data are located in the original master database.

3. We installed the same MSDE version (or at less, pretty sure it's the same) on the target machine. The new installed MSDE system has its own master, model, etc.

4. We tried to start the new MSDE installation from the acquired master.mdf and ldf files, but it won't. MSDE complains about an object ID 8762964 missing in the catalog, and should run DBCC checktable on the database.

5. We tried to do a sp_attach of the acquired database, but MSDE complains about a problem in the file header: "Msg 5172 16,15: mastlog.ldf is not a valid file header. PageAudit property incorrect".

6. We did succesfully sp_attach another database (not the master) from the same old machine.

7. The machines are quiet different. The old machine is a Windows98 tablet PC and the new one is a WindowsXP Tablet PC edition.

8. The old MSDE installation was pretty ill mantained. For instance, the ldf file is 1.2 Gb long for a 250Mb mdf file. In fact, the idea to migrate the application was to provide a more constant access to the application.

Please help, what should be our next move? I don't want to go to the "guessing" phase, and if we are going back to the warehouse, we should have a plan.
0
estrelow
Asked:
estrelow
1 Solution
 
ispalenyCommented:
You don't need to restore master database, just use EM DTS to transfer logins and EM Copy database wizard to transfer databases.
0
 
ispalenyCommented:
EM is SQL Server Enterprise Manager
DTS is Data Transformation Services
Copy database wizard is available from mmc console menu Tools-Wizards-Management when you select anything under server node.
0
 
Brendt HessSenior DBACommented:
I will refer you to the following link:

http://vyaskn.tripod.com/moving_sql_server.htm

This is the most complete and correct listing of the steps needed to move a database from one server to another that I have seen.

Note that your error about "mastlog.ldf is not a valid file header. PageAudit property incorrect" could indicate a version mismatch.  Look at the article referenced above to see your path forward.
0
 
estrelowAuthor Commented:
Ok, I'm taking ispaleny's advice.
I just set up a Personal MSSQL 2000 to get access to EM (MSDE doesn't get it), working with EM makes a lot of sense.
I successfully attached the old master database with a different name. I'm seeing the data now.
I couldn't use database wizard though. I don't have network access to the running database, since it's on the fork lift.

The production site should be MSDE though. Let's see if I find the way to go back to MSDE. Probably I'll end up buying a license.
0
 
arbertCommented:
Ym, you should never restore the master database from one machine to another--playing with fire.  There are just too many machine dependent settings to even attempt this type of restore.

Brett
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now