I'm new in Express Edition.
We use SQL 2000 on our SBS2003.
For disaster recovery I installed SQL Express on a laptop.
How can I move database and application from SQL 2000 to
Eexpress edition?
Many thanks
Peter
One of the easy ways is to just do a backup and recovery, but I would also look at the upgrade adviser and make sure that the application can be upgraded. If you are doing the sharpoint databases from sbs you can use the sql express install system to upgrade the instance.
|||Glenn.
Did you mean use SQL server 2000 backup utility to backup all Dbs then setup Express Edition, then use its recovery to restore
Dbs? One of my friend suggested just copy all .MDF and .LDF files, then use SQL server Management Studio Express to link them.
We don't use Sharepoint database.
Thank you for your attention.
Welcome your further advise.
Peter
|||Hi Peter,
Yes, you can backup using SQL 2000 and then restore using SQL Express just as you suggest. You can also just copy your MDF/LDF files into the Data directory for SQL Express and then use Management Studio to Attach those files.
In either case, the resulting database file in SQL Express can not be moved back to SQL 2000, the file formats are not compatible.
Mike
|||
Hi Mike,
Thank you for your advice.It’s important to know “the resulting database file in SQL Express can not be moved back to SQL 2000, the file formats are not compatible.”
My project is for disaster recovery, in case of SBS2003, SQL 2000 running on it, down.
I have to restore database after SQL 2000 server comes back online.It looks like I can’t use SQL Express as backup.
Can I use MSDE? I think its data file format is same to SQL 2000. If it can, could you please let me know how to do that? Do we still need Management Studio to attach database?
Many thanks
Peter
No comments:
Post a Comment