asked on

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?

Daniel Wilson

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?

SOLUTION

Norush

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

edster9999

The best way to do this is to take a full backup and restore it to your server

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

tcmmaxt

ASKER

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

SOLUTION

edster9999

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Daniel Wilson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tcmmaxt

ASKER

all great answers and sharp experts