Hey, thanks for replying. I have also been using this statement. Probably, I did not post it up here or maybe against some other post. Sorry for that.

Thats fair enough. I am not interested in scripting maintenance plans.

I will look into it.

This forum is a real help. Thanks folks.

Got a problem When I tried to restore, it terminated as it said that backup can not be restored as it was taken by...

Thanks a lot everyone. I will try this and if there's a problem, you would see me again. Just that its a prod system, so I am a bit shaky.

Thanks...

Here comes the problem. We have different server names

Any hints on how we should proceed.

Please do reply.

Regards,

Madiha.

Thanks for the reply.

However, my question is that if someone other than dba has to create the dbs using batch files, you would not want them to have sa rights....

 Thanks a lot for your reply. I got a bit of relief. Anyway, below is the original message. Thanks again.

I am new to DBA role.Hope I can benefit from...

Thanks for your reply Arun. You probably replied to my other query as well; by mistake I posted it on another forum.

Anyway, I had set the filegrowth factor to 10% as...

What do you disagree with? I don't get it. Could you please add as I am not able to follow the chain.

Thanks,

Madiha.

From what I understand is that Global groups are at database level while local groups are at server level. What do we need local groups for; plus when we have given...

Perhaps this might help you-I checked Event Viewer and it appeared that a scheduled routine failed and after that all messages that were there were like 'Scheduler1 hung up', 'Scheduler2...

I am using SQL Server 2000. I would like to add here that I restarted the machine and it worked!!

I checked the protocols etc. and the only different thing that...

Thanks. That was really helpful.

I just remember vaguely it being mentioned in one of the posts that the built-in built-in administrator account should not be deleted.

Madiha!