How to make copy of demo database to test database

[kothandaraman_nagarajan]

Dear Experts,

How to make copy of demo database to test database?

Please help on this.

Thanks,

Nagarajan

[KennedyT21]

Hi Naga Rajan...

Does the Issue closed or Not if closed the close the thread with correct or helpful answers

Regards

Kennedy

[Former Member]

If you mean to create a new copy of your database you need to use sql server management studio.

Create a backup of your existing database, create a new empty database and restore your back on then new database.

SBO will automaticaly see the new db as a new company. If you don't see the new company on the company list just click the update button on the window

Hope it help

Regards Valerio

[kothandaraman_nagarajan]

Hi,

Thanks for reply.

I am not familiar with management studio.

How to create backup, new  empty database and restore it? Give me direction in SQL management studio.

Thanks,

Nagarajan

[Former Member]

Hi Nagarajan...

Please check this video.

This may help you....

http://www.youtube.com/watch?v=eK526X3UhMM

Regards,

Rahul

[kothandaraman_nagarajan]

Hi,

Thanks for reply. But not looking for backup database.

Looking for creating copy of one database to another database. For example, I have demo database and then make copy of this database as test database.

[Former Member]

Hi Naga is not possible to copy db on another db because some of stored procedure in sbo database are encrypted.

For create a copy you need do do 3 steps :

1. Backup your source db
2. create a new one
3. restore the db on your new database

All this operation are made using sql managemente studio.

You can find detailed information on this 3 links

Backup

http://msdn.microsoft.com/en-us/library/ms187510(v=sql.100).aspx

Create

http://msdn.microsoft.com/en-us/library/ms186390(v=sql.100).aspx

Restore

http://msdn.microsoft.com/en-us/library/ms186390(v=sql.100).aspx

it is a bit complex to explain in detail how to do all this operation but i try.

For backup your db you need to :

1. open sql management studio and login on your sql server
2. click on the right button of mouse on db you want to backup
3. in the menu click on tasks and then in the new menu backup
4. In the new window be sure to choose the option "full" on backup type and in the bottom part of window add the destination of your backup ( be sure the blank space is empty before you add your destination)

For create new db :

1. click on the databases root with the right button of mouse and choose new database
2. Specify the name of your new db

For restore db

1. Click on your new db with the right button
2. choose tasks -> restore
3. Choose from device and using the button [...] choose the backup you done precedently.
4. on the left pane click on options
5. choose in the right pane Overwrite the existing database 

Hope it help

Regards Valerio

[Former Member]

Hi Nagarajan...

Then you must use Copy Express...

That may help you to achieve....

Regards,

Rahul