Restoring database...

Hi!!!
Database and all information about it was deleted (from Enterprise Manager)
but earlier a backup hade been made.
How can I restore this database?
Thanks!
TimurTimur
Assuming that you are running SQL Server 2000 (or 7.0), make sure that the
account you do the restore from has CREATE DATABASE rights (which sysadmin
will have) and do a RESTORE.
If you are on 6.5 the job is harder. Reply if that is your problem.
Russell Fields
"ôÉÍÕÒ" <tim_@.pochtamt.ru> wrote in message
news:uEa7dhC7DHA.3704@.tk2msftngp13.phx.gbl...
> Hi!!!
> Database and all information about it was deleted (from Enterprise
Manager)
> but earlier a backup hade been made.
> How can I restore this database?
> Thanks!
> Timur
>|||Provided that the backup was taken with a maintenance plan
or with enterprise manager this would be easy. In
Enterprise Manager, you can expand databases under the sql
server name, right click on any database, select All
Tasks, and click Restore Database. On the general tab in
the Restore as database field select the name of the
database you want to restore or type in the database name
if it isn't there. Next to restore you have 3 radio
buttons, Database, Filegroups or files, and From device.
Select the restore method from one of these buttons. If
you have in fact taken a backup prior to deleting the
database then this should be straightforward. You can
also use the restore database command from within query
analyzer. For the proper syntax see Books OnLine for this
method.
Tim Bridges
MCSE, MCDBA
SQL Server DBA
>--Original Message--
>Hi!!!
>Database and all information about it was deleted (from
Enterprise Manager)
>but earlier a backup hade been made.
>How can I restore this database?
>Thanks!
>Timur
>
>.
>