How to restore sql server database?

-- Anonymous, March 26, 2004

Answers

Senthil,

Using Enterprise Manager, right click on the database, select All tasks, Restore database..., pick one of the backups to restore, and click OK.

Using Transact SQL, use the basic command is:

RESTORE DATABASE myDB FROM

Hope this helps,

Eric

-- Anonymous, March 30, 2004