Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mark360
Starting Member
5 Posts |
 Posted - 2007-03-31 : 14:29:34
|
| Hi,I have made a backup of a sql 2000 database that was on the server at work and and I would like to use it in sql 2005 express on my home laptop.Can anyone help? I can't seem to work out how to do it. Do I restore it or re-attach it? Is it possible?Sorry if these are basic questions.Mark |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-31 : 15:08:26
|
| You can either restore it or attach it. Make sure to set the compatibility mode to 90, reindex all the tables/ update stats on all the tables . Detach/Attach is like cut/paste. You detach from your source server and attach it to the target server. so, at anytime you are working on the same file. In backup/restore your db will still exist on the source server. So you will end up with the db on the source as well as destination server.************************Life is short. Enjoy it.************************ |
 |
|
|
Mark360
Starting Member
5 Posts |
Posted - 2007-03-31 : 15:44:31
|
| Thanks for that, I have got it working. Also, thanks for explaining the differences between the two. |
|
|
|
|
|
|
Attaching sql 2000 db to 2005