IF Backup Devices Deleted

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

Dennis Post SSCarpal Tunnel Points: 4473 More actions · Answer 1

Hi,

Windows search on *.bak.

Goodluck.

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

Konuri Dinesh SSC Enthusiast Points: 105 More actions · Answer 2

i don't think answer is that much easy

If my Backup file on different server ,in which i don't have access on that server? what can i do?

Dennis Post SSCarpal Tunnel Points: 4473 More actions · Answer 3

Ask to get permission, or ask someone else to look for you. 🙂

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

Dennis Post SSCarpal Tunnel Points: 4473 More actions · Answer 4

If you have any other backup devices, check out where they are pointing to. Maybe the file you need is in the same location.

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

durai nagarajan SSCoach Points: 15778 More actions · Answer 5

select * from backupmediafamily

this table will have where the last backup happened.

Regards
Durai Nagarajan

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 6

I would recommend that you stop using backup devices - setup the maintenance plan or your backup scripts to use a separate file for every backup.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll