[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 901
  • Last Modified:

Howto replace the ldf / mdf files of ms sql 2005 express edition with a stack of files from a different installation

Hello,

I could need some help with the MS SQL 2005 Express Edition. We want to reuse datafiles from a different installation.
Right now I've got just standard dataspaces (oracle speech ;-) and I want to use a different dataspace, with all needed tables filled with the right data.

Is there some nice way to import that data, or is it suffcient to copy & paste the datafiles into the right folder?

This is what I've got for replacement:

17.760.256 master.mdf
2.883.584 mastlog.ldf
786.432 model.mdf
524.288 modellog.ldf
3.145.728 msdbdata.mdf
786.432 msdblog.ldf
8.388.608 tempdb.mdf
524.288 templog.ldf


These datafiles require the data to resist in the folder C:\Program Files\Microsoft SQL Server\MSSQL$BSI\Data\

Any ideas?

Tolomir
0
Tolomir
Asked:
Tolomir
  • 3
  • 2
  • 2
3 Solutions
 
ptjcbCommented:
http://support.microsoft.com/kb/224071

You probably do not need to move the tempdb files, they are used to create scratch tables during queries. The tempdb is recreated every time you stop and restart SQL Server.

0
 
BrughCommented:
You want to replace the System Databases?

Is there a particular reason for that?  Normally this is a bad idea. :)

Also, the TEMP DB is going to re-create itself everytime you stop/start SQL.

Here is some information on System DBs for ya.

http://msdn2.microsoft.com/en-us/library/ms178028.aspx
 - Brugh

0
 
TolomirAdministratorAuthor Commented:
OK, I've got an update on this.

The application we want to use is based on Microsoft SQL Server 2000 Desktop Engine.

The drawback is, as it seems, there are just 2-3 concurrent connections allowed.

We thus like to migrate from the small database to ms sql 2005 express server.

Is there a way to accomplish this, maybe some data export / import?

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
BrughCommented:
I would check with yoru Application Vendor first.

You still wouldn;t need to migrate your System DBs, just the USER DB(Application DB) and it should work without error. However, it all depends on the application that needs to access the DB.

Also, some infromation on SQl 2005 Express limitations:
http://technet.microsoft.com/en-us/library/ms345154.aspx


 - Brugh
0
 
ptjcbCommented:
DO NOT MOVE THE SYSTEM DATABASES.

You are talking about moving the system databases from 2000 to 2005 and that will corrupt the 2005 database. The system databases are: Master, MSDB, tempDB, and Model. The Master database has everything about your system and database. The MSDB has everything about SQL Server jobs. The Model is used to create new databases, and as I mentioned before, tempDB is used for scratch tables.

The issue is that there are significant differences between 2000 and 2005. You cannot just plug in the Master db from a 2000 server into 2005.

I agree with Brugh, you should talk to your vendor first.

Does your vendor support SQL 2005? If not, then any issues that you have from this moment forward will always come back "We don't know. We don't support SQL 2005." and if you have paid money for support you have just thrown it away.

0
 
TolomirAdministratorAuthor Commented:
1st at all this currently is a test. I haven't bought the application, I'm just the one who as to check if the migration is possible.

For sure I would not mix system databases of different versions, but when I asked the question, all I had were the datafiles. Now I got at least the application (30 days trial) and I found:

 
MS SQL 2005 Server Upgrade Technical Resource Guide

+

MS SQL Update Assistent...

keep you updated.
0
 
TolomirAdministratorAuthor Commented:
Thank you for the help.

since this leads to nowhere, I redefined the question (since now I got much more detailed information about the needed version...)

If you are interested checkout:

How can I migrate a MS SQL 2000 Desktop Edition to the full (120 days trial) sql 2000 server?
http:/Q_22743990.html

Thank you,
Tolomir
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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