you can use sp_who2 to check blocking.

What error you got??

Then you start from top.First revoke sysadmin privileges and give less privilege to them better restrict them to database roles and then you can implement.

I did master rebuild using the below script but still getting the same error

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName /SQLSYSADMINACCOUNTS=accounts [ /SAPWD= StrongPassword ] [ /SQLCOLLATION=CollationName]

Got this from windows error log. Going for master rebuild as i dont have a backup.

Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 537, state...

Thanks for the reply. Its not a cluster just a standalone server.

give server name as smtp.gmail.com and check the ssl.

Try the below link.

http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx

You sure its the last step failing??

Check the backup location and make sure any files are available for the maintenance plan to delete.

Thanks Again 🙂

sqldba_newbie (10/22/2012)

---

I know there are many different forums out there related to tempdb, but i couldn't find the one which suits my requirements. While i do more research i just...

Thanks Roshan,

So you meant to say SIMPLE Recovery model can cause VLF to grow???

Thanks a lot Gail..You are awesome..

Thanks Gail,

The DB got recovered.

In a blog i read that SIMPLE recovery mode can cause high recovery interval since its not possible to take log backups and taking frequent log...

How AD administrator?? You mean by adding to any group??

I am domain admin and local admin..

If i have SA password or any other sysadmin login credential then why this...

Just for testing. Successfully downgraded by using uninstall updates under the UNISTALL PROGRAMS.