Question Locked

SQL 2000 DB Recover

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to restart an old project from I just have a Database Backup and the names of the database and server. How can I recover this backup without knowing table's name or structure in SQL Server 2000?
I tried just creating a new database (all default options, no tables), creating a backup, substituting it with the one I have and no exit.
Any ideas?

2 replies

by alexisgrey2004

Use Sql Server 2000's restore database option. Select the database backup from the list and select ok on the Restore database backup dialog

This discussion is closed to new replies.