how to recover deleted database objects

Question

Post reply

how to recover deleted database objects

haroonjaved786

Newbie

Points: 1
More actions
March 12, 2008 at 7:22 am

#179981

after power failuer one table in sql server 2000 database has been removed unexpectedly . any one have solution to recover that table from that database ,there is no any database backup available

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 1

Sorry... the table is pretty much toast, then.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

tosscrosby SSCoach Points: 18045 More actions · Answer 2

Amazing how many times I've seen a similar post over the past couple of weeks! One of the first tasks a DBA must do when getting the job is to ensure you have reliable backups of your enterprise data. I'm not trying to place any undeserving criticism on anyone but this a a very basic requirement of the position. If you can be sure that you can recover most, if not all, of your data, your ready to move on to the bigger and better tasks of your position. Your lack of ability to recover your data can cripple a business and effectivley end your career with that company. Here is one of MANY available checklists found on the web that should be a starting point for anyone unsure of what they should be doing.

http://www.mssqltips.com/tip.asp?tip=1240

-- You can't be late until you show up.

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 3

Heh... it's what separates all these "Hi, I'm new to DBA" people from the real DBA's.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)