Viewing 15 posts - 196 through 210 (of 860 total)
Alright great, Thanks Jefferey. One more doubt cleared 🙂
April 14, 2009 at 2:59 pm
Musène Jonas (4/14/2009)
Thanks, he's just a Commercial Director, may be he's afraid to spend
I would say it's a DBA's primary responsibility to show someone how a poor maintenance of their...
April 14, 2009 at 2:48 pm
And also I think it wouldn't be a clean shut down of SQL server as in WITH NO WAIT but I am not so sure though.
April 14, 2009 at 2:45 pm
Hi,
Yes, you can turn on trace flag 3231 which will turn NO_LOGS and TRUNCATE_ONLY no ops
Thanks,
April 14, 2009 at 2:42 pm
And if hes still not sure, he can post here with any concerns he has and we would be glad to help your friend out 🙂
April 14, 2009 at 2:35 pm
Musène Jonas (4/14/2009)
Please be hard, if you can send to me the explaination via e-mail i would...
April 14, 2009 at 2:33 pm
Musène Jonas (4/14/2009)
these check have to be made every week if i do not want to loss many data
Yes, both for DR plan and also to safe guard your databases....
April 14, 2009 at 1:55 pm
Gail and Me have already advised you about the plans. Are you still not clear about it?
April 14, 2009 at 1:40 pm
Musène Jonas (4/14/2009)
I have three years ofexperience and there is no senior DBA around
Hello Musene,
Then can you please make your answer clear to what we have asked?
April 14, 2009 at 1:39 pm
Musène Jonas (4/14/2009)
I have got many insert
Gail made it clear, that's what I wanted to ask. I thought probably you would of know what I meant.
Thanks a lot Gail.
April 14, 2009 at 1:13 pm
Musène Jonas (4/14/2009)
We make posting after invoicing, we e-mail statement, we have accountants that make they job on the database etc..
More insight into this please? I mean have you got...
April 14, 2009 at 12:18 pm
Musène Jonas (4/13/2009)
from step 5, i have to these tests each month, each week, each day. give me an answer please.we invoice everyday from 8h to 14h
It depends, what are...
April 13, 2009 at 3:30 pm
Musène Jonas (4/13/2009)
everything that can keep database in healthy
It depends on your business model.
But a basic plan goes like this:
1.) Full backups Everyday or Weekend at off hours
2.) Differential backups...
April 13, 2009 at 3:16 pm
Hi,
What did you mean by this? Are you asking about maintaining indexes?
Well Daily maintenance includes backing up the database, veryfying database backups, defragging/rebuilding indexes, Updating statistics etc..
April 13, 2009 at 2:55 pm
Have you got any jobs scheduled that manipulated sql server services. check out any sql agent jobs and also dont include your sql server files when you are scanning your...
April 13, 2009 at 7:59 am
Viewing 15 posts - 196 through 210 (of 860 total)