restore databasegreenspun.com : LUSENET : SQL Server Database Administration : One Thread
How to restore sql server database?
-- Anonymous, March 26, 2004
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,
-- Anonymous, March 30, 2004