Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-29 : 12:25:31
|
| Smith writes "How to restore a database from a backup file of SQL Server" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-29 : 12:26:01
|
| Ummmmmm...the RESTORE command, perhaps?You can find a ton of details on it in Books Online. |
 |
|
|
aliddell
Starting Member
6 Posts |
Posted - 2002-08-30 : 00:04:04
|
| In enterprise manager- Right click Databases|All tasks|Restore Database- If it's a new database, type the name, otherwise select dropdown- Select restore type "from device"- click select devices, click Add, find the backup file (must on be physical drive)- Back on the retore options, select the Options Tab- Force restore if you have to, set location of mdf/ldf- click okAL |
|
|
|
|
|
|
restore