How do I duplicate someone else's existing SQL database on my MS SQL 2005 Server?

EXPERT: I need to copy/duplicate someone else's existing MS SQL database on to my MS SQL 2005 Server and want to know what steps do I have to get this done and what stuff they have to give me (scripts ?) etc?
Who is Participating?
Daniel WilsonConnect With a Mentor Commented:
SQL 2005 likes to make a single script.

Right-click the DB, choose Tasks, Generate Scripts, and complete the wizard.

You will need to run the script in Query Analyzer / Sql Server Management Studio when you get it.
Daniel WilsonCommented:
the easiest thing to do is have them give you a backup which you then restore.

You can get the DB scripted & run those scripts against a new DB.  that will give you structure, but not data.

Do you need just the structure?  Or the data too?
NorushConnect With a Mentor Commented:
1. Ask the other party to make a backup of the database.
2. They will send you the backup file
3. You will restore the database on your server.

Usefull links for restoring are:
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

The best way to do this is to take a full backup and restore it to your server
tcmmaxtAuthor Commented:
DanielWilson: thank you (and everyone else):  I just need the structure, their data will be of no use.

"You can get the DB scripted & run those scripts against a new DB" ?  Are these individual script files that I have to cut and paste into what's you guys call the query analyzer? are do you import and somehow download the DB scripts to my new database?

Sorry I am not DB smart

tcmmaxtAuthor Commented:
all great answers and sharp experts
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.