How can I have a local copy of SQL server database?

I want to have a local copy of my SQL server database on a laptop (windows 2000 professional) so that I can demo the project on the client's site. I'm not sure if I can do it by MSDE. And is that possible to write the data back to SQL server after changin
g the local copy? Thanks a lot.
Ada Wang
You can for instance take a backup of the database and restore it on the other machine. Or use sp_detach_db
and sp_attach_db. Watch out for orphaned logins, though (read about sp_change_users_login in Books Online). If
you restore from your laptop to the server, it will overwrite the whole database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"ada" <anonymous@.discussions.microsoft.com> wrote in message
news:EFE651B5-A3E3-45A5-BB4C-07EBAF682314@.microsoft.com...
> I want to have a local copy of my SQL server database on a laptop (windows 2000 professional) so that I can
demo the project on the client's site. I'm not sure if I can do it by MSDE. And is that possible to write the
data back to SQL server after changing the local copy? Thanks a lot.
> Ada Wang