Thanks a lot Jack and Gail for your wonderful suggestions and good pointers towards the issue.

I agree we need to increase the frequency of the consistency checks and the next...

The fastest way would be to script your QA environment Logins and permissions and then restore the Prod backups in QA and add your QA login back.

or

Since there is no...

1.Can you try to change the location of the backup to some other Drive and check if you r facing the same issue ?

2.Also, what is the result if you...

Dear Shashank,

If your Maintenance Plan runs with sa password and if you do a Password reset for sa account, you need to manually open up the Maintenance Plan Package ...

Shashank, Good Post!! I have a query on this.. Once we change the owner of Maintenance Plan,

Is there a script we can use to update the password for that account?

EveryTime...

Thanks for confirming that its the default behaviour 🙂

PLease refer this Link to troubleshoot your issue :

http://msdn.microsoft.com/en-us/library/aa337440.aspx

Hi rocky,

What I understand from the below link is that REVOKE doesn't cancel a GRANT. It doesn't block a GRANT. It removes a permission at the level specified to the...

Thanks Gail.

And for the above issue, I think I got the solution...

I had to explicityly grant connect on TCP Endpoint to every login after the Connect permission was revoked from...

Also, I had a very scary moment todaye after trying to fix the non compliance for the policy 'Public not granted server role.'

I executed the below query to get rid...

Hi

Thanks for the reply. So you mean to say I can register these 2005 sql servers on a sql 2008 instance and evaluate the Policies from there? Please let...

I need one small clarification if you can assist.

In the datediff function, the second date will always be an earlier date than the first in my case (i.e getdate())....

Hi

Thanks a Ton for pointing out the COnversion Miss..!! It helped a lot!!!!

Hi Krishna,

You must be aware that restarting the Sql Server services can free up all the space for tempdb, but this is not a solution for a very busy 24*7...

Is it a vM machine? usually Its the VMware backups or Net backups that backs up our Disks generates these messages since it takes a full backup of everythng on...