Restoring Databases

[Mathew03]

Hi,

I have more than 200 databases.These are backed up
using a maintenance plan.Each backup file has the name of the database with the timestamp as the filename.

1.How Can I restore the dbs without individually restoring them ? Is there any method?

2.I also have a backup of the mdf and ldf files of these dbs.How can I restore the databases with these data& log files?

Please Help.

Thanks in advance

Mathew

 

[nigelrivett]

2. Look at sp_attach_db. If the server wasn't offline at the time or the databases detached then these will probably not be attachable though.

1. You can restore them all with a script - the same as you could have backed them up without using the external app.

see

http://www.nigelrivett.net/BackupAllDatabases.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.