Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I restore a single SQL Server 2000 object?
- Thread starter btturner
- Start date
tlbroadbent
MIS
SQL Server does not have single object retore capability. When You need to restore singles objects, you should restore the database to a different location. Then copy the object(s) to the original DB.
My normal procedure is to restore to a database on the same server if there is sufficient disk space. I append a suffix on the database name to mark that database as a restored DB. For example, when I need to restore an object in the HR database, I restore the backup to HR_Restore. Then I copy the object to HR. Terry L. Broadbent
Programming and Computing Resources
My normal procedure is to restore to a database on the same server if there is sufficient disk space. I append a suffix on the database name to mark that database as a restored DB. For example, when I need to restore an object in the HR database, I restore the backup to HR_Restore. Then I copy the object to HR. Terry L. Broadbent
Programming and Computing Resources
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question