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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
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?
ASKER
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?
Well, when you right click on the Databases container, do you see an option to Attach a database?
ASKER
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. ??
So - to do this right:
1. Stop applications
2. Backup all the old(2000) and new (2005) databases
3. ??
4. ??
ASKER
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!
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!
>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
yes, you need to use the restore functionality
ASKER
What about the Attach command mentioned by dbaduck (above)? Should this be used, and what's its purpose? Thanks for all help so far!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm learning all the time. Thanks!
Is backup / restore recommended over attach? (since the versions are different)?
Is backup / restore recommended over attach? (since the versions are different)?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When you attach, it automatically upgrades the database just like when you restore, so they are equal in that respect.
ASKER
Worked just fine! Thanks.
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