Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
unclejackqwerty
Starting Member
2 Posts |
 Posted - 2003-09-22 : 10:43:35
|
| All, I need help with the following, I think I allready no the answer, yet I am trying to remain positive and hoping for a solution.Situation is as follows:SQL Server 2000. Backup strategy: Full Backup on Friday, Differential every day. This strategy was NOT adhered too!!Full Backup done in July, differential after that. Full Backup taken last week. Differential since then.Knightmare!! -- Latest Full Backup was overwritten by latest Differential!!!Is there anyway to get the data that is on the last Diff backup??Appreciate any help.No I Did not do this, I'm just here to clean up!!-- The truth is hard to find and even harder to obscure -- |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-22 : 12:54:12
|
| Oops.The differential only contains data that has changed since the full backup - so without the full backup you are probably stuck.Just noticed in bol under differential backupsImportant Use extreme caution when using the FORMAT or INIT clauses of the BACKUP statement as this will destroy any backups previously stored on the backup media.But the people who did this probably know that now.I always append yyyymmdd_hhmmss to the backup file name to prevent this sort of thing.dbname_FULL_yyyymmdd_hhmmss.bakdbname_DIFF_yyyymmdd_hhmmss.bakdbname_LOG_yyyymmdd_hhmmss.bak==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-22 : 13:32:37
|
| Do you copy any of your backup files to tape? If so, then just go to the tape prior to the file being overwritten and restore that file.Tara |
|
|
|
unclejackqwerty
Starting Member
2 Posts |
Posted - 2003-09-23 : 04:07:00
|
| I thought I was up poo creek without a paddle. Tduggan this is a tape backup. Thanks for your thoughts though people.-- The truth is hard to find and even harder to obscure -- |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-09-23 : 11:24:55
|
quote:
Originally posted by unclejackqwerty
I thought I was up poo creek without a paddle. Tduggan this is a tape backup. Thanks for your thoughts though people.-- The truth is hard to find and even harder to obscure --
That was funny. Anyway, take nigel's advice, append a timestamp to the end of your backup so this doesn't actually bite you. When you have to perform a recovery, you will want to be able to restore every file from tape you need in one shot. If the backups all have the same filename, your recovery process will be a nightmare.-ec |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-23 : 11:26:51
|
| Also, it is recommended that you do not backup the database directly to tape. You should back it up to disk first then copy the file to tape. This will speed up recovery because you probably already have the files on disk if the disk is still available.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-23 : 21:24:57
|
| Odd - I've just come across yet again "None of our backups prior to this week are restorable".It was quickly followed by forgetting to add the new backup jobs for over a week.(From a dba who gets very upset when I suggest things - like suggesting 3 days in a row that a system with a full disk that keeps giving tempdb full error messages isn't a good thing. On the forth day the system crashed, lost the disk, no restorable backups, ...)When will people learn that backups and backup procedures are only useful if you test them.Another one was a web site and the host company was in charge of the backup and restores. The test was to ask them to backup all databases and restore them on the standby system - it succeeded for all the databases (lots of paperwork and completed tests).When asked to restore a database from a specific date the response was "We only backup the databases when you ask us to".They were also meant to be in charge of implementing log shipping (no need to test that - it was all their responsibility). When asked how they did this with the databases in simple recovery mode "We haven't implemented this we don't have any sql server expertise".==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-24 : 12:19:34
|
That is too funny!  Tara |
|
|
|
|
|
|
|
|
Differential Backup -- Disaster Help Me Please --