Viewing 15 posts - 1 through 15 (of 1,160 total)
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...
September 16, 2011 at 3:24 am
GilaMonster (9/5/2011)
Adiga (9/5/2011)
Your restore script does not have "WITH RECOVERY" option in it. Hence the database is in Recovering state.
Errr, RECOVERY is the default if nothing is specified. To...
September 5, 2011 at 10:25 am
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...
September 5, 2011 at 10:15 am
Adiga (8/9/2011)
Naresh,Check if restarting the SQL Server instance before restoring the database helps.
How could that help?
I have seen this error due to BPool/Memory pressure on instances running on 32 bit...
August 9, 2011 at 6:08 am
Naresh,
Check if restarting the SQL Server instance before restoring the database helps.
August 9, 2011 at 5:42 am
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...
August 7, 2011 at 10:03 pm
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...
July 15, 2011 at 11:11 am
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.
July 15, 2011 at 1:53 am
Please check the event logs for any errors related to disks.
May 14, 2011 at 10:58 am
April 19, 2011 at 10:22 am
Does the SQL Server service account has sufficient privileges on the drive/file "S:\MSSQL\DatabaseName.mdf"
April 14, 2011 at 12:15 pm
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...
April 11, 2011 at 12:56 pm
2011-04-10 07:51:58 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2011-04-10 07:51:58 Slp: Message:
2011-04-10 07:51:58 Slp: The service did not start due to a logon failure.
The service is not starting due to logon failure....
April 10, 2011 at 2:17 am
Viewing 15 posts - 1 through 15 (of 1,160 total)