connecting to external DB

hi,
am working with my friend so we need to use the same DB ..how can i get him DB and insert it in mine to use it.
i 've try to copy it and paste in C:\Program Files\Microsoft SQL Server\MSSQL\Data then try to connect it by New connection bt it doesn't work
Note:am working n Web Matrix Project
Regards,You use the backup and restore wizard to backup the database and take the .bak file and put it in the Backup subfolder in the same Microsoft SQL Server folder and then go to Enterprise Manager and use the backup and restore wizard and use the restore from device option. BTW I think you can only delete from the Data subfolder and not add to it because that is where SQL Server stores the MDF and LDF data files. Post again if you need more help. Hope this helps.|||hello,
thank u very much for ur effort, but please can u explain how to Backup the Database with Extention .mdf .ldf
and there is no folder inside (Microsoft SQL Server) should i create it?
thanx for giving my Q ur valuable time,|||The database is not backed up with mdf and ldf files backup creates .bak file and it is found in this directory. You get mdf and ldf files when you execute a create database statement or you use Enterprise manager to create a database. The next step is you put the .bak file you created in the other computer in this directory and go to Enterprise manager and use the backup and restore wizard and choose the restore from device option. Run a search for backup and restore in the BOL (books online). Hope this helps.
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP