| Author |
 Topic  |
|
mcrowley
Aged Yak Warrior
771 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8513 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
|
|
JCirocco
Constraint Violating Yak Guru
USA
392 Posts |
 Posted - 10/07/2009 : 13:39:33
|
I just stumbled onto the Yak Corral and loved the reading. In my past 3 positions, every tech admin was required to read, understand and live by:
http://www.taobackup.com/
Great stuff. 12 years old and still relevant.
John |
 |
|
|
blindman
Flowing Fount of Yak Knowledge
USA
2365 Posts |
Posted - 10/08/2009 : 08:47:04
|
Cute, except for its promotion of Veracity.
I haved seen far too many clients implement Veracity as a database backup system and think they were getting backups when they were not.
________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________ |
|
|
|
JCirocco
Constraint Violating Yak Guru
USA
392 Posts |
Posted - 10/08/2009 : 10:42:01
|
LOL, I am oblivious to any advertising and didn't even notice that. I print the pages up through epilogue as handouts...
And a backup does not count unless tested...
John |
Edited by - JCirocco on 10/08/2009 10:43:29 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 10/08/2009 : 10:52:39
|
quote:
Originally posted by blindman
Cute, except for its promotion of Veracity.
I haved seen far too many clients implement Veracity as a database backup system and think they were getting backups when they were not.
________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
The links for Veracity go to this site: http://www.quantum.com/
A search of that site returns no hits for "Veracity".
Veracity is a dead product, Jim
CODO ERGO SUM |
Edited by - Michael Valentine Jones on 10/08/2009 10:55:54 |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/21/2010 : 05:15:46
|
Oh dear! "One of the biggest database can't be backup in normal mode in Sqlagent.And also can't be cold backup.MDF can't be copy though the sql service is stopped completely. The worst thing is we don't have the latest backup of this database"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138651 |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/21/2010 : 07:23:15
|
Believe it or not, I think that one is fixable without data loss. It's only one of the nonclustered indexes that's damaged (index 2)
Guess this is a case where luck favours fools.
--
Gail Shaw
SQL Server MVP |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/21/2010 : 08:04:52
|
| I wasn't sure when I looked at the error list - data seemed to be found for which there was no corresponding index pointer. But its not my strong suite, I would prefer to rely on Backups rather than Rescue! |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/21/2010 : 08:55:49
|
Likewise.
All the errors are in index 2. That's the key. If there's nothing I missed, this can be fixed with no data loss.
--
Gail Shaw
SQL Server MVP |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/30/2010 : 04:49:12
|
quote:
Originally posted by Michael Valentine Jones
Database disks and backup disks all corrupted at the same time and don't have any tape backups, Jim.
http://www.sqlservercentral.com/Forums/Topic856307-146-1.aspx
And the corruption is irreparable because the damage affects allocation pages and system tables.
--
Gail Shaw
SQL Server MVP |
Edited by - GilaMonster on 01/30/2010 04:56:05 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/30/2010 : 05:17:36
|
Yesterday @ 8:17 PM "This is our financial database and I need it up pronto"
...
Yesterday @ 11:02 PM "There was nothing Microsoft could do... I have to recreate from scratch!! Big bummer!!"
Sounds like either a) years of work or b) tiny DB |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/10/2010 : 13:30:11
|
http://www.sqlservercentral.com/Forums/Topic863241-266-1.aspx
Damaged system tables, damaged allocation pages, then went and detached the suspect database.
Last couple months I've been seeing a lot of irreparable corruptions. Don't know if that's because more is happening or that people are managing to fix the fixable stuff themselves.
--
Gail Shaw
SQL Server MVP |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
|
|
Topic |
|
It's dead, Jim
