restore with replace

I was testing a restore using a backup of db1 and
restoring to db2. Both db1 and db2 already exist and have
the same file structure. The restore was also moving the
db1 files to the db2 file locations. I did not specify
with replace. I expected the restore to fail, but it
didn't. What am I missing?Through a job in EM. Below is sql.
restore database SynComp_219
from disk = '\\hfddbms1p\d-
drive\mssql\backup\synygy_1t_1206a_0711.bak'
with
move 'metadata_001' to 'D:\MSSQL$INST1
\Data\metadata_IC_APP\metadata_001.mdf',
move 'datasets_001' to 'D:\MSSQL$INST1
\Data\metadata_IC_APP\datasets_001.ndf',
move 'indexes_001' to 'D:\MSSQL$INST1
\Data\metadata_IC_APP\indexes_001.ndf',
move 'logs_001' to 'E:\MSSQL$INST1\log\logs_001.ldf',
recovery,
stats = 5
>--Original Message--
>GM
>How did you perform restore command ? by T-SQL or EM.
>"GM" <gamaglia@.lnc.com> wrote in message
>news:9cf201c35c29$0ee50350$a001280a@.phx.gbl...
>> I was testing a restore using a backup of db1 and
>> restoring to db2. Both db1 and db2 already exist and
have
>> the same file structure. The restore was also moving the
>> db1 files to the db2 file locations. I did not specify
>> with replace. I expected the restore to fail, but it
>> didn't. What am I missing?
>
>.
>

Restore SQL 2000 database onto a SQL 7 box

Is it possible to restore a SQL 2000 database backup onto a SQL 7 box?

I tried and it quite rightly complained about database structure versions are different.

Is there a way to backup SQL 2000 in such a way that only SQL 7 features are preserved? and thus can be restored on to a SQL 7 box.

The database it self is really quite simple. Just tables (plus data) and SPs.No you can't restore a 2K database onto a 7 box. You can use DTS to move data OR BCP the data out of the 2K box and into the 7 box.

Restore objects from backup.

Hi experts,

Is there any way to restore the table structure or stored procedures alone from a database backup ?

Thanks & Regards,

DBLearner

There are no direct ways to that. Anyway, you could restore database with another name on the server and copy whatever you want from it.
|||When restoring a SQL Server backup you have to restore all the data. After restoring you can trucnate the tables which will give you the schema and procedures only.|||

No there is no way to restore a table structure from a database backup without restoring the entire database.

regarDs,

Jacx