SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Lost Data


Lost Data

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)

Group: Administrators
Points: 147920 Visits: 19443
Comments posted to this topic are about the item Lost Data

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Dave Schutz
Dave Schutz
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2228 Visits: 609
Steve,

I agree, tape backup is still a requirement for us. We are a non-profit and disk backup is too expensive for more than a few days worth of data. I make daily, monthly, and annual backup tapes so there is a plan B if plan A backup fails. Tapes can fail so test restores often.
I'd rather be old-school (tape backups) than lose data and possibly my job.
kevin77
kevin77
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2186 Visits: 1102
Ha. This is my exact situation right now:

http://www.sqlservercentral.com/Forums/Topic926228-266-1.aspx

I've known about the error for over a month now, but management doesn't care because "the application still works for them". So I can't get the time and necessary resources to fix it.



Steve Jones
Steve Jones
SSC Guru
SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)

Group: Administrators
Points: 147920 Visits: 19443
Sorry to hear that, Kevin. Keep your fingers crossed and hopefully disaster doesn't strike.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Tom Bakerman
Tom Bakerman
Right there with Babe
Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)

Group: General Forum Members
Points: 765 Visits: 931
I once worked with a customer that had a finite number of tapes that they used for their database backupsCrazy. Their database was big enough to have to use slightly more than one tape for each backup. So, when the time came to actually have to restore the database (due to a bad disk causing corruption), they discovered that the only complete backup set was the latest, and it too had the corrupted data on it. They wanted me to "recover as much as you can from an earlier backup", which of course was impossible because parts of the backup had been overwritten by a later backup. Needless to say, they came up with a better strategy AFTER that.
SQLBill
SQLBill
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11745 Visits: 1085
I worked at a job where we the database outgrew the room for being able to do a restore and have two copies of the same database at the same time.

Before that had happened, we were using a third party backup software provided by the vendor knowing exactly what equipment we had and how it was set up. We did a backup and restore with no problem. Some time goes by and now the database is too large for two copies of it and we don't have another server large enough to restore a backup tape to. We updated the software and unfortunately the vendor didn't notify us or anyone at the time that their software would fail if:

1. you were using SQL Server 2000 Enterprise Edition
2. you were using Windows 2000 (some service pack, can't remember now)
3. the server was clustered
4. you were using the vendor's SQL Server agent add-on to backup SQL Server and it was a specific build.

1, 2, 3, & 4 -yep to all.

If you answered yes to all four, their product would not be able to restore the databases from the backups. Guess what, they only notified us of the issue AFTER we had a server issue and needed to restore from tape. They ended up recovering the tapes for us so we could do the restore and they 'ate' the cost of doing so, since they couldn't prove they had informed us of the issue prior to it happening.

-SQLBill



Russell Fields-270604
Russell Fields-270604
SSC-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 Visits: 605
Get a RestoreTest server (a VM would be fine) and enough disk space to restore your biggest database (plus necessary overhead).

Then cycle through your servers, restoring the backups one at a time to your RestoreTest server. (You will need to harvest the necessary data on backups from msdb of each SQL Server.) The process:

1. Restore a database, report any errors.
2. Delete the restored database.
3. Repeat with the next database.

Also, don't just restore full and diff backups. Include your transaction log backups as well.

When you start doing this you will probably find more problems than you imagined would exist. But once these are all smoothed out, you will sleep better.

RLF
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search