restore 1 table

[onressy]

I'm having issue restoring 1 table from a databse, i made a copy of the db on another server and am having problems mounting the db cause the tranaction log is over 1.5 gigs. I was wondering since the table info was deleted accidentially, is that a way to roll back that sql command via the transaction log? Thanks

 

[Catadmin]

You can only roll back the deletion of the table if you have some sort of auditing programmed into your DB or if you have a third party tool like Lumigent Log Explorer or the Apex SQL Log tool (don't remember the name).

Do the problems you're having with mounting the DB have to do with not enough hard drive space or is it just taking a long time?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[onressy]

Thanks CatAdmin, i managed to get it mounted, it was taking too much time and had issues compacting it, thanks forthe product suggestions, will look into that, cheers and thanks again

 

[Catadmin]

NP. Glad I could be of some assistance. @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"