so if the restore worked thats not the problem. What status does the database show as in SSMS?

What does 'select state_desc from master.sys.databases' return for your database

If the name...

have you tried to restore? please share the restore command you used and what was the error?

interesting article and good timing.

we hit a problem only yesterday where an ETL process was blowing tempdb (940GB then it ran out of space). This was fixed with a query...

ok, I see. Glad you sorted that.

so you have a sqlagent alert but its not working?

set up an alert in SQLAgent to monitor for 9002 errors

I have had posts ignored before but this is getting ridiculous.................:-)

run updateusage and sp_updatestats

pleasure.

with microsoft products that use SQL server as a backend they often don't follow their own best practices 🙂

the code as written must work better if parallelism is suppressed, seems...

m.rajesh.uk (3/9/2013)

---

i am getting the below error while taking the backup via maintence plan.. i am getting an error only for one particular database and rest been completed successfully.

Please advice...

hopefully this URL will get you started and answer your queries

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

from msdn:

The number of rows that are displayed for audit logs can be configured on the SQL Server Object Explorer/Commands page of the Tools/Options dialog box

if resources are scarce its not for me to tell your company how to spend their money but a new server in prod to allow a side by side build...

thats what happens when you do other things whilst replying, Gail pops up :-), but at least you have confirmation now.