July 13, 2010 at 8:46 am
River - First it sounds like as Paul stated the database is corrupted or possibly you are not on the same version of SQL Server as the customer. Have you verified your version to theirs? If the database is corrupted, then you have a major issue since obviously regular backups do not occur.
To answer your other question of where do you get April - July from, where does the data come from and do you have a way to recreate it? Sounds like you have learned a very major lesson.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 13, 2010 at 8:47 am
this client is crazy... don't know what to do with them....
Ok, thanks for the support.
One last comment that may be important. The database is now with the satus of Suspect/emergency
July 13, 2010 at 8:47 am
You wont, this is why you should take backups regularly. Most places I have worked with take a Full each night and a t-log backup every 15 mins. What you decide for your client depends on the level of risk and how important the data is to them
Your client should have been aware of the risk of loss of data when not taking regular backups
July 13, 2010 at 8:49 am
they don't care, it's Africa, people are not responsible (my client). Only when problems happen
July 13, 2010 at 9:09 am
That is truely a great attitude. Did they understand what needed to be done to maintain the database as well as the consequences if they didn't?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 13, 2010 at 9:11 am
yes , they did, but they don't care , it's difficult to explain... And now , because of this the problem is mine...
July 13, 2010 at 9:22 am
river1 (7/13/2010)
And now , because of this the problem is mine...
Why? Does your contract/agreement make you responsible for the databases? I gather you are not an employee of this company.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2010 at 9:25 am
Yes Gail, but in Africa if you want to maintain the business, you have to be prepared for this situation (accepts blaims)...
It complicated, but thank you very much for all the help.
July 13, 2010 at 9:30 am
Yes Gail, but in Africa if you want to maintain the business, you have to be prepared for this situation (accepts blaims).
I am confused. Contractually, are you responsible for the database, and it's day to day operation?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 13, 2010 at 9:32 am
Not in terms of contract.
July 13, 2010 at 9:47 am
river1 (7/13/2010)
Yes Gail, but in Africa if you want to maintain the business, you have to be prepared for this situation (accepts blaims)...
No you don't. If it's not in the contract, you are fully permitted to walk away. If they demand, it's probably business that you don't want, business that's costing you more than it's worth.
And don't tell me that I don't know how things work in Africa.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2014 at 1:40 am
river1 (7/13/2010)
thank you for reply again paul.I can't put the database in emergency mode...
How can i put the database in emergency mode in SQL Server 2000?
------------------------------------------------------------------------------------------
Hello Paul, I am also facing the same problem as above for one of my database.
Can you share the email details to me.
By Rajesh.
May 26, 2014 at 2:16 am
Please post new questions in a new thread and give as much detail as possible. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 13 posts - 16 through 27 (of 27 total)
You must be logged in to reply to this topic. Login to reply