Good one Luis..
The important aspect of DBA role has been highlighted by Luis here that Backups are foremost factor to save your data or provide point in time recovery, but there is a catch that don't assume that if you have taken backup your data is safe. You must restore the backup on a standby server or if you don't have one occassionally restore it on other name to ensure the backup file is consistent or not corrupted.
A kind of DBA you need isn't really a matter of which DBMS program you're using, but what you're using it for, so the key to success is monitor and fine tune pro-actively rather than waiting for a problem to happen.

Thanks a lot, Satya and Luis.
I have some more questions.
1. Can somebody please, let me know what type of database can have most difficult schema and how can we fix it?
2. Can we create a report in reporting service if the data is in Oracle?
Thaaanks a lot

[quote user="Rabani"]
Can any body tell me that what can be the reason that a store procedure was working till yesterday but doesen't today and how can we fix it?
Thanks a lot
[/quote]
First thing to make sure is that the code of the procedure didn't change. Nor the code calling the procedure. I know, we developers always say that nothing changed, but it is still worth checking that. []

Frustation is your best friend if you panic and asking open-ended questions without any clues, as referred by Adrian it is better to open up new threads for problems and before that make sure to search thru the forums for relevant tips & references.