From the screenshot it appears that you are using SQL Server 2005 Express Edition. SQL Server Agent is not available in that edition. You may have to use some other...

GilaMonster (9/5/2011)

Errr, RECOVERY is the default if nothing is specified. To...

Your restore script does not have "WITH RECOVERY" option in it. Hence the database is in Recovering state. Please issue RESTORE DATABASE [your db name] WITH RECOVERY now. The database...

I have seen this error due to BPool/Memory pressure on instances running on 32 bit...

Naresh,

Check if restarting the SQL Server instance before restoring the database helps.

Starting SQL Server 2008 SP1, you can using the Add/Remove applet in Control Panel to uninstall Service Packs.

In SQL Server 2005, service packs cannot be uninstalled. Hence you need to...

Hi Gangadhar,

Now backup verification is failing because of "There is insufficient system memory to run this query" error. SQL Server is running out of memory. You may try the backup...

Gangadhara,

From the error message it appears that the backup set is invalid. The only option it fix this is to initiate a new backup.

Please check the event logs for any errors related to disks.

You can read the Default Trace[/url] to get that information.

You may find this article[/url] useful.

You may find this response useful.

Does the SQL Server service account has sufficient privileges on the drive/file "S:\MSSQL\DatabaseName.mdf"

The password for the SQL Server and related service account would have changed after the service was started. Does the SQL Server 2000, Agent service start if you try restarting...

The service is not starting due to logon failure....