[Webinar] Streamline your web hosting managementRegister Today

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

SQL Server 2005 Express - more instances

I'm running two applications on SQL server 2000 - under Win2003 server. Just installed another application that came with SQL server 2005 Express (can't run app. on SQL 2000). Looking for ways to move the 2000-apps over to 2005 Express, but don't know how. The Express version has very limited admin tools....  Are there any tools available to do this, or any tips or ideas how to do it?
0
Olaf Berli
Asked:
Olaf Berli
  • 7
  • 5
  • 3
3 Solutions
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
stop the application first then
you can either move the databases or restore the latest backup from 2000 machine to the 2005
once you have done that,  change the connection string to point to the new location, take offline the databse on 2000 server
you may have to test the application before it completely goes live because there are some major differences b/w  2000 and 2005 server engines
0
 
Olaf BerliAuthor Commented:
Have downloaded the Express Manager and can see both servers there. What I can't see is any backup or restore functions. On the 2000 server I have the full Enterprise Manager and I'm using that to make the backup. In the Enterprise Manager I can't access the 2000 server, and in Express (2005) manager I can't see any restore functions.  Any ideas?
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
DBAduck - Ben MillerPrincipal ConsultantCommented:
You would have to use the RESTORE TSQL command.

RESTORE DATABASE dbname FROM disk='path to backup'

But in this case I would almost use Attach and Detach before backup and restore.

Do you see Attach in the Express Manager?
0
 
Olaf BerliAuthor Commented:
In Express Manager I see "Connect" and "Disconnect". When using disconnect I'm able to connect to the 2000 server and see the databases. Is this what you mean?


0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
Well, when you right click on the Databases container, do you see an option to Attach a database?
0
 
Olaf BerliAuthor Commented:
Yes, the Attach option is there - as well as *Restore database'

So - to do this right:
1. Stop applications
2. Backup all the old(2000) and new (2005) databases
3. ??
4. ??
0
 
Olaf BerliAuthor Commented:
My previous comment was probably not very clear....  Sorry.

Found the Attach option, but not sure how to use it.
From previous comments, it seems like first step is to stop all applications using SQL server, and make sure that there are backups of all databases.

Then a restore of the backups from the 2000 server onto the 2005 server. Could the restore function in the Manager tool be used for this?

More detalis on this would be great.  Thanks!
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
>Then a restore of the backups from the 2000 server onto the 2005 server. Could the restore function in the Manager tool be used for this?
yes, you need to use the restore functionality

 
0
 
Olaf BerliAuthor Commented:
What about the Attach command mentioned by dbaduck (above)? Should this be used, and what's its purpose?  Thanks for all help so far!
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
attach method cant be used to attach the backups, instead its used to attach the original db files (the .mdf and .ldf ) for  using this, you need to copy these files of the database to the new location and attach it from there
0
 
Olaf BerliAuthor Commented:
I'm learning all the time. Thanks!
Is backup / restore recommended over attach?  (since the versions are different)?
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
I recommended attach because when you copy the .mdf and .ldf files to the new location and then attach, you don't have to use the Move command or do it in the GUI.

But you can do either, I just recommend Attach in this case because it is Express.
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
When you attach, it automatically upgrades the database just like when you restore, so they are equal in that respect.
0
 
Olaf BerliAuthor Commented:
Worked just fine!  Thanks.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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