SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 It's dead, Jim
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 17

mcrowley
Aged Yak Warrior

771 Posts

Posted - 08/19/2009 :  10:28:38  Show Profile  Reply with Quote
Same old same old
http://www.dbforums.com/microsoft-sql-server/1646663-sql-server-2008-record-retrieval.html
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/19/2009 :  10:55:32  Show Profile  Reply with Quote
Dropped a database, don't have a backup because it isn't critical, but I need to restore it.

http://www.sqlservercentral.com/Forums/Topic773514-146-1.aspx


CODO ERGO SUM
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8683 Posts

Posted - 09/07/2009 :  10:22:59  Show Profile  Visit webfred's Homepage  Reply with Quote
Do it again, Sam.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132383


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 09/12/2009 :  07:38:43  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I ignored all warnings and now I need the truncated data back.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132696


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 09/30/2009 :  11:46:14  Show Profile  Reply with Quote
Urgent....that I not tell you anything in the subject line.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=133690
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

USA
392 Posts

Posted - 10/07/2009 :  13:39:33  Show Profile  Visit JCirocco's Homepage  Click to see JCirocco's MSN Messenger address  Reply with Quote
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
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 10/08/2009 :  08:47:04  Show Profile  Reply with Quote
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.
________________________________________________
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

USA
392 Posts

Posted - 10/08/2009 :  10:42:01  Show Profile  Visit JCirocco's Homepage  Click to see JCirocco's MSN Messenger address  Reply with Quote
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
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/08/2009 :  10:52:39  Show Profile  Reply with Quote
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
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 10/13/2009 :  15:01:52  Show Profile  Reply with Quote
Yeah, but we have been running for two months like this....

http://www.dbforums.com/microsoft-sql-server/1648926-repair_allow_data_loss.html
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/18/2010 :  03:59:43  Show Profile  Reply with Quote
No backups ... None over on SqlServerCentral either ...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138433
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/21/2010 :  05:15:46  Show Profile  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/21/2010 :  07:23:15  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/21/2010 :  08:04:52  Show Profile  Reply with Quote
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!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/21/2010 :  08:55:49  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 01/29/2010 :  18:11:04  Show Profile  Reply with Quote
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





CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/30/2010 :  04:49:12  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/30/2010 :  05:17:36  Show Profile  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/10/2010 :  13:30:11  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/11/2010 :  03:25:39  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
http://www.sqlservercentral.com/Forums/Topic863019-357-1.aspx
Drive failed, only got the ldf file, how do I get the DB back?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
Page: of 17 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000