This might be a good place to start

http://support.microsoft.com/kb/827422

The purpose? It increases performance.

Thanks for your time and response.

I came across this though it applies to 2K:

http://msdn.microsoft.com/en-us/library/aa258257%28v=sql.80%29.aspx

"Each database has an owner who has the ability to perform special activities in the...

My question is somewhat related to the original question...

Whether the database owner is the database creator as well? I mean is there any way to find out who created a...

Hi!

I don't think you can find out without using triggers.

Thanks for your response. I'm aware of the Invoke-Sqlcmd Cmdlet option but was looking for a more straight forward solution. Looks like there's no way to pull the error msg...

Thanks I've already read those. The strange thing is that it sometimes succeeds and sometimes fails. I give it up. :unsure:

You could also use PS

DB tracking script:

http://www.mssqltips.com/tip.asp?tip=1759

Disk size monitoring should not be too hard either to implement. Just google it!

Thanks for your time.

There's no related entry in the SQL Server Agent Error Log and according to the most recent SQL Server Log the databases were backed up successfully.

The maintenance...

Hi,

Could you post that query?

Hi!

A few things you could try then: check disk space on drive, try to change the path to another drive (if possible). Also check logs to find out more details...

Hi!

Have you tried DBCC CHECKDB? If so, any errors?

Hi,

You can also go through the SQL Server Tacklebox and set up the repository.

http://www.sqlservercentral.com/articles/books/67536/

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