March 22, 2009 at 9:01 pm
can we re store in db just one table
March 22, 2009 at 10:06 pm
Not with SQL Server.. but you can do this:
Restore the database in another database with different name.
Drop Table (or truncate)
Recreate table (if dropped)
Then copy all the information over.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 25, 2009 at 7:40 am
Mohit is correct, in Sql 2000 you can not restore individual tables but can restore to a new database and then copy over the individual table. There are third party backup software products that you can restore an individual table.
I'm not sure if this is available in 2005 or 2008.
Steve
March 25, 2009 at 9:20 am
steve block (3/25/2009)
I'm not sure if this is available in 2005 or 2008.
It's not, and it's highly unlikely that it will be available in future versions.
MS is against giving built in tool that can result in transactionally inconsistent databases. Restore individual table to some historical point can, if related tables aren't also restored result in inconsistent data
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply