INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- Turn Off Ad Banners
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...Keep up the good work - excellent site - i'd been looking for something like this for ages !..."
Geography
Where in the world do Tek-Tips members come from?
|
Microsoft SQL Server: Programming FAQ
|
Restoring SQL Database
|
Restoring Database in MSSQL 7
Posted: 21 Jul 00
|
Copy the backup file to the MSSQL7 > BACKUP folder. Start Enterprise Manager, select your server from the Sql Server Group.
To restore database, right click onto the Databases folder icon and choose All Tasks > Restore Database. Type in the name of your database, and choose to restore from device. Click on select devices, Add and the … box to browse. Select your database file and ok, ok again, and ok once more. Under the options tab, click onto “Force restore over existing database. Make sure that the Move to physical file name is listed as c:\whatever. Mine always comes up as d:\whatever.
Clck onto Ok and stand back.
|
Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum
My FAQ Archive
 Email This FAQ To A Friend |
|
 |
|
