how to recovery data without backup?

Question

Post reply

how to recovery data without backup?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
October 15, 2008 at 11:55 am

#72959

hi friends,
Without backup how to get old 3 days data, , so we try to select old data but it was come 11th satarday data only,but after 11th day data does not come, and we do not have Tlog backup and full backup.
Any one give me tips, how to recovery data?
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

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

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 1

Did u have updates in the past 3 days??

How much of data do u expect you would need to recover??

What about the backups, when was it run the last time, if so why was it not running for the last 3 days??

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

ananda.murugesan (10/15/2008)
Any one give me tips, how to recovery data?

To put it very bluntly, you don't.

Why don't you have backups?

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Here's an answer you might hear where I work:

The SAN will never go down.

:hehe::cool:

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Lynn Pettis (10/15/2008)
Here's an answer you might hear where I work:
The SAN will never go down.

Yeah, right. Sure it won't. <sigh>

I actually have seen a SAN go down. Not only go down, but it scrambled data on the drives as it did. Guess what, the only backups were on the SAN.

Bye bye database...

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

That's why I keep pushing for multiple offsite file servers. All I want is 4 distributed around the district (we are a K12 public school district) where I can push compressed/encrypted backups for DR purposes. We keep getting promised one, but still haven't seen it.

We have a tape backup system, but the tapes are only removed weekly but have had issues with those as well.

😎

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 6

SAN goes down???...:w00t:. I am glad we have a one year tape backup retention policy..:cool:

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Gordon-265412 SSCrazy Points: 2898 More actions · Answer 7

The_SQL_DBA (10/16/2008)
SAN goes down???...:w00t:. I am glad we have a one year tape backup retention policy..:cool:

And how often do you test recovering from those tapes? Nothings worse than going to tape and finding bad or unusable tape....

Your friendly High-Tech Janitor... 🙂

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 8

Gordon (10/16/2008)
And how often do you test recovering from those tapes? Nothings worse than going to tape and finding bad or unusable tape....

Well, for me there was never a need to do a tape restore:crazy: ...but its better than screaming :w00t: that I dont have a backup..

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Gordon-265412 SSCrazy Points: 2898 More actions · Answer 9

The_SQL_DBA (10/17/2008)
Gordon (10/16/2008)
And how often do you test recovering from those tapes? Nothings worse than going to tape and finding bad or unusable tape....
Well, for me there was never a need to do a tape restore:crazy: ...but its better than screaming :w00t: that I dont have a backup..

While that may be very true. Without testing your tapes, you don't know for certain wether they are valid. Tape has a very high failure rate.

Every two weeks when the offsite rotation comes back from the vault, we pull the data and run RESTOREVERIFYONLY on the db's that CHECKSUMs as part of thier backup, and full restores if CHECKSUM is not available.

I see a lot of people that think they're safe just because "it's on tape" when in fact they are not. I've been bitten by this once, and only once. I try to evangelize that people test and recover the data off of thier tapes, so that they don't get bitten either.

Your friendly High-Tech Janitor... 🙂