Copy SQL for co-worker

I am new to SQL Server.  
I am working on a project with another person.  I created a SQL DB and want to transfer it to his machine intact so he can start working with it.  We are not connected thru a network.

I see some utilities for backing up or copying the DB but wondered what the steps are to make a copy of this DB to send to him?  Then what files do I need to send to him?

On his end what steps does he need to take to bring the DB into his SQL environment?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dirk MareSystems Engineer (Acting IT Manager)Commented:
Use SQL Server Management Studio to make backup and then again on the other side to restore the backup.

You did not mention what version of SQL you are using but the backup and restore function hasn't changed much over the past couple of versions.

Watch this short video on Youtube and that's about it.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vikas GargAssociate Principal EngineerCommented:

Simply right click on database
Select Task - Backup
In destination check mark disk
click on ADD
give suitable path and file name
This will created .bak backup file.

Now to restore it on destination
send this file to the destination machine via pen drive

Right click on the databases and click on restore

Select the .bak backup file
and thats it
mlcktmguyAuthor Commented:
Excellent, the video was very clear, even for a NUB.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.