How do I back up my DB to a zip drive or another disk?

[Guest_imported]

Hi, I am new to sql server. I could not find a way of backing up my db to a zip disk. I am doing a project witha vb app to front end a sql server db. I may have to present this at a forum. How do i copy my db files to removable media like a zip drive? Also what are *.mdf files If i do manage to copy the db to another zip drive (small enough for that) , how do I start SQL server on the other machine so that t can open the db i copied on a zip disk? Please help.Thanks. - jay.

 

[tlbroadbent]

You can run sp_detach_db (See SQL BOL) to detach the DB from SQL Server. Then copy the .mdf and .ldf files for your server to the zip drive. On the other machine, copy the fiules to the proper SQL Server data location and run sp_attach_db. You'll also need to run sp_attach_db on the original SQL server to reattach the database.

SQL Books Online has complete documentation of detaching and attaching. Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes