Do you mean,You want to create a copy of an existing database?

in short words, yes

1.Go to Enterprise Manager and right click the databases and create a new database

2.Right click the database which you created and select the ALL Tasks and then select IMPORT DATA

3.Now you should see DTS Import/Export Wizard.Hit next. Select the option Choose the data Source,Under the database select the database which you want to take a copy of.Hit next

4.Your destination will be the new database which you created.Select it and Hit next

5.Select the option Copy tables and source from the source database.Hit next

6.Hit the option Select all

7.Hit next and next until the tables start copying

8.All the tables and views will be stored on to the new database.

Hopy it Helps

thnx, that helped a lot!

Do u known how to use replication of data base in sql server 2008