July 23, 2007 at 9:24 am
Hai,
Can any one tell me, how to recover a single/selected object from a backup media.
For ex:
1. I have a db with some tables and sprocs.
2. I took the backup of my db.
3. Later I created a new db and want to restore only a few/selected objects(from my tables, sprocs) from my previously taken backup file.
Thanks,
Y.Kiran Kumar.
Regards,
-Kiran
July 23, 2007 at 9:57 am
I think Litespeed can do this. Not sure about the other backup tools.
There is no way in SQL Server to do this other than restore the database as a new name, then copy out the objects.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 23, 2007 at 12:49 pm
If you have the space somewhere else, just restore it to a development server and then DTS the objects back over.
July 23, 2007 at 4:15 pm
And of course your database must be in "Full" recovery mode.
_____________
Code for TallyGenerator
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply