MS-SQL7 transfer databases

[Tung Nguyen]

Hi there,

I would like to make multiples copies of a database. What I used to do in MS-SQL 6.5 was create a backup of the database that I want to make copy from. Create new (empty) databases and restored the backed up database into the new databases. Another way that I used to do is to use the Database Transfer feature in the Enterprise Manager.

I want to do the same thing in MS-SQL 7 (beta 3) but it seems to me that I couldn't do that. First, there is no Database Transfer feature like that in 6.5. Next, I couldn't restore a backed up database to another database.

I know there is the Import/Export utility but it is the last thing I have to use if I don't have any other choice.

Thanks in advance for your help.

Tung Nguyen

[Ajay]

HI,


Here it is more simpler to create a copy of database.
Dont create any database devices. Click on the backup file that has to be duplicated and say restore. It will first create the device of the same size and than restore the database over it...

Regards
Ajay