Viewing 15 posts - 46 through 60 (of 1,157 total)
Deleting the backup files on UAT instance will not affect the PROD instance. To delete the files you need to have FULL permissions on the folder. If you are making...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 1, 2011 at 6:51 am
Please go through the SQL Server setup logs as explained in this article.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 1, 2011 at 4:23 am
Duplicate post. All responses at http://www.sqlservercentral.com/Forums/Topic1070515-146-1.aspx
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 28, 2011 at 9:12 am
You can also enable Database Mail [/url]and configure the job to send an email when the job fails.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 28, 2011 at 9:11 am
Most probably from the Help --> About screen.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 23, 2011 at 1:09 pm
AFAIK, it is easier for the PSS engineers to analyze the mdmp files and there are some symbols which are not available to everyone.
Since I am not an expert in...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 23, 2011 at 8:25 am
The DBA has to contact MS PSS in this case. You may find this link useful in contacting PSS.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 23, 2011 at 7:50 am
From the error message it appears that the SQL Server is under memory pressure and was not even able load "dbghelp.dll" which is required for generating the dump files.
It...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 23, 2011 at 7:18 am
Do you get any errors if you run SQLAGENT.exe from the command prompt? This exe is usually located at C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 18, 2011 at 2:13 am
I could not reproduce that issue. Since you are on SQL Server 2008 RTM, check if applying SP2 helps in resolving this.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 16, 2011 at 11:42 am
You may find this article useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 15, 2011 at 6:43 am
Even though this article refers to SQL Server 2008, it is applicable to SQL Server 2005 as well.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 14, 2011 at 8:33 am
The SQLAGENT.* file which has a modified date of <=7:30 should have information how the SQL Server Agent was stopped.
If the Agent was not running under Local System account earlier,...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 8, 2011 at 11:38 am
Krasavita (2/8/2011)
Yes, it is running now from 956 am
What is the issue? May be I have not understood it correctly.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 8, 2011 at 11:24 am
SQL Server Agent seems to be running. Last update at 2011-02-08 13:00:07. Do you still see process id 2096 in the Task Manager?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 8, 2011 at 11:14 am
Viewing 15 posts - 46 through 60 (of 1,157 total)