| Author |
 Topic  |
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
 Posted - 03/16/2012 : 11:14:10
|
And that's probably not recoverable, SQL 2000 as well to make matters more fun.
How can you 'forget to start SQL Agent' for 5 years?
--
Gail Shaw
SQL Server MVP |
Edited by - GilaMonster on 03/16/2012 11:14:47 |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
russell
Pyro-ma-ni-yak
USA
4993 Posts |
Posted - 03/16/2012 : 12:39:08
|
quote:
Originally posted by GilaMonster
And that's probably not recoverable, SQL 2000 as well to make matters more fun.
How can you 'forget to start SQL Agent' for 5 years?
--
Gail Shaw
SQL Server MVP
I'd argue that there is no such thing as a "DBA" that "forgot" to make sure backups are running (and good). |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 03/16/2012 : 12:55:14
|
quote:
Originally posted by russell
I'd argue that there is no such thing as a "DBA" that "forgot" to make sure backups are running (and good).
I can't bring myself to even answer that post.. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 03/16/2012 : 13:23:09
|
quote:
Originally posted by X002548
quote:
Originally posted by sunitabeck
OMG! I just feel bad for the person.
WHY? Someone has to say
Because, I don't want to judge someone until I have walked a mile in their shoes. In a subsequent post, the OP also said this:quote:
db admin forget to start sql agent to auto back or any other Solution
The OP may be in this situation because of an incompetent DBA. Or, it may be that the OP inherited this database; it could be the 3rd day on a new job; or it could be any number of other things on which s/he had no control over or did not have enough skills.
So, I do feel bad for them. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 03/16/2012 : 14:32:35
|
Aaahhhh!!! Never, never, never, never detach a suspect database, it makes matters worse not better. That situation just went from unlikely to be recoverable to almost certain not to be at all recoverable.
--
Gail Shaw
SQL Server MVP |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 03/16/2012 : 14:45:06
|
quote:
Originally posted by sunitabeck
quote:
Originally posted by RickD
New candidate..
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=172549
OMG! I just feel bad for the person. Five years worth of data and absolutely no backups!! What a sad and bad predicament to be in!!!
It's like seeing a bad traffic accident. You feel bad for them, but you're really happy it isn't you.
CODO ERGO SUM |
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 03/16/2012 : 23:14:55
|
they could hire Paul Randal to open up the mdf and ldf in a hex editor and save it maybe :)
elsasoft.org |
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
yoursurrogategod
Starting Member
14 Posts |
Posted - 02/19/2013 : 14:46:35
|
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by spirit1
damn it Bones!!!
can't you fix it? 
Go with the flow & have fun! Else fight the flow 
Blog thingie: http://weblogs.sqlteam.com/mladenp
I'm a DBA, not a magician!
CODO ERGO SUM
To some, knowing a bit about computers makes it seem like you have magic powers, simply because they don't know what you know :) . |
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
|
|
JaybeeSQL
Yak Posting Veteran
77 Posts |
Posted - 04/17/2013 : 12:56:39
|
Like Sunita, I have EVERY sympathy for ANY man who asks for help doing his job. All this derision is quite tasteless.
|
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
Posted - 04/18/2013 : 12:54:52
|
quote:
Originally posted by JaybeeSQL
Like Sunita, I have EVERY sympathy for ANY man who asks for help doing his job. All this derision is quite tasteless.
1) why reply to a year old part of the thread?
2) Derision is NOT tasteless when it is deserved. Trust me, i have had my share  (quiet Fred!)
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 04/18/2013 : 22:47:10
|
quote:
Originally posted by JaybeeSQL
Like Sunita, I have EVERY sympathy for ANY man who asks for help doing his job. All this derision is quite tasteless.
The links on this thread are almost all about hopeless situations.
The only help here is a warning to others to make sure that they have backups.
I post a link to this thread whenever I see someone questioning the value of backups.
CODO ERGO SUM |
|
|
|
Topic |
|
It's dead, Jim
