You may find Brian Kelley's response in this discussion useful.

Check if the "Results to File" option in SSMS meets your requirement.

Most likely this is a permissions issue of the SQL Agent startup account. Check if there are any entries in the Agent Log

@ravz.sqldba, "Automatically remove agent history" option not remaining selected is a BUG which even I can reproduce. However when you select it and click ok, all data older than the...

I would leave 85% of total RAM available to SQL Server.

RESTORE VERIFYONLY FROM DISK='......'

More information here

You can query the BACKUPSET table in MSDB to get information on successful database backups.

The service account details can be obtained by reading the registry. Here is an example.

DECLARE @ServiceaccountName varchar(250)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

@ServiceAccountName OUTPUT,

N'no_output'

SELECT @ServiceaccountName

I second Steve. Stopping SQL Services before installing SP/hotfix is a common misconception.

Here it is

Like John said, make use of the Cleanup Task in Maintenance Plan. It is very easy to accomplish

Hi Sudhakara,

Check the job properties if "Quit reporting Success" is selected when the job fails. Add an output file to

the job step. This will give you more details regarding...

The easiest way query multiple servers using GUI is the SSMS in SQL Server 2008. But it has limitation that it cannot be scripted or run using a job. You...

Hi Senthil,

This KB article explains how to restore from transaction log backups.

Are Differential db backups necessary to restore from trans logs backups (point of failure)? Or can I just use the Full db backup to restore and then restore all...