Cancel Restoration

Question

Post reply

Cancel Restoration

pawantanwar87

Valued Member

Points: 51
More actions
April 9, 2010 at 3:49 am

#233650

by mistake my database have been replaced by old backup of same data base.how to get back of my previous database

Viewing 12 posts - 1 through 12 (of 12 total)

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

BrainDonor SSCoach Points: 19269 More actions · Answer 1

Restore from the latest backup that you have - that's about as current as you'll be able to get.

BrainDonor

Steve Hall
Linkedin
Blog Site

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

pawantanwar87 (4/9/2010)
by mistake my database have been replaced by old backup of same data base.how to get back of my previous database

I agree with Brain.

Do you have all latest backups?(full,diff&logs)

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

joeroshan SSChampion Points: 10377 More actions · Answer 3

Restore latest full backup and subsequent log backups.

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

pawantanwar87 Valued Member Points: 51 More actions · Answer 4

i don't have back up of new database.i only have backup that is 7 days old..

pawantanwar87 Valued Member Points: 51 More actions · Answer 5

i don't have latest backup.i only have old back up that was replaced by latest backup.......

steveb. SSC-Forever Points: 46733 More actions · Answer 6

did you overwrite the data files when you restored the old backup?

if so, there is not a lot you can do

pawantanwar87 Valued Member Points: 51 More actions · Answer 7

i don't have latest backup.i only have old back up that was replaced by latest back up.

pawantanwar87 Valued Member Points: 51 More actions · Answer 8

i don't have latest backup.i only have old back up that was replaced by latest back up.

steveb. SSC-Forever Points: 46733 More actions · Answer 9

There is not much you can do, I hope this isn't a production database,

GSquared SSC Guru Points: 260824 More actions · Answer 10

pawantanwar87 (4/9/2010)
i don't have latest backup.i only have old back up that was replaced by latest back up.

Then you've lost a week's data. There's no way to recover from backups that don't exist.

Is it possible to re-enter data? What type of database is this?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 738693 More actions · Answer 11

What does "I have an old backup that was replaced by the last backup" mean? Which files, and from when, do you have?