September 17, 2001 at 12:12 am
How can I take backup/restore of a perticular table from my database?
Deepak
September 17, 2001 at 4:56 am
Backup and restore is done at the database level, or at the file group level - so if you put your table in separate file group you could achieve your goal that way. I don't use filegroups, so in my case I'd backup the entire db, then to restore a table I would restore the backup to a NEW db, then DTS the table over to the original db.
Andy
February 8, 2006 at 8:03 am
That was one of the best/simple solutions I have read on this website to date. I am still an entry level DBA, and your discussion pointed me in the exact direction I needed to be.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy