Home Forums SQL Server 2005 Backups Read MS SQL 2000 backup file without restoring the database RE: Read MS SQL 2000 backup file without restoring the database
Greg Charles
SSC-Forever
Points: 45403
More actions
September 7, 2007 at 11:48 am
#732239
Kedar,
Although there isn't a native SQL Server object restore, you can restore a database backup to a new database using the 'WITH MOVE' option of the RESTORE DATABASE command. Then, you can copy the table back into the original database.
Greg