Viewing 15 posts - 61 through 75 (of 113 total)
This will give you all information you need
exec msdb.dbo.sp_help_job @execution_status=1
You can refer BOL to get different values of @execution_status
June 11, 2012 at 10:34 am
I believe this is issue with NTLM security.
When you try to connect linked server from server B (logged into server B and using SSMS) it should work.
When you are...
June 7, 2012 at 2:32 pm
Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 10.0.0.xx
Error: 18456, Severity: 14, State: 58.]
This error message...
June 7, 2012 at 2:08 pm
To run profiler ALTER TRACE (server level) permission is required
To compare schema VIEW DEFINITION permission is required
according to BOL,
The VIEW DEFINITION permission can be granted on the following levels:
Server scope
Database...
June 7, 2012 at 12:41 pm
Can you run this and check the location of T-log and Full backup?
SELECT a.name,a.database_name,a.user_name,a.backup_start_date,a.backup_finish_date,a.type,
cast((a.backup_size/(1024*1024)) as numeric(10,2)) backup_size,
cast((a.backup_size/(1024*1024)) as numeric(10,2))/
case when datediff(ss,a.backup_start_date,a.backup_finish_date)=0 then 1 else datediff(ss,a.backup_start_date,a.backup_finish_date) end [MB/Sec],
b.physical_device_name,b.device_type
FROM msdb.dbo.backupset a
join msdb.dbo.backupmediafamily...
June 7, 2012 at 6:31 am
Maintenance Plan is executed under SQL agent account and some of the tasks can be EXECUTED AS plan owner's account (http://sqlblog.com/blogs/tibor_karaszi/archive/2009/09/19/sql-server-agent-jobs-and-user-contexts.aspx)
When you are trying to restore the database (either SSMS...
June 6, 2012 at 9:13 am
2012-06-05 10:32:02.47 spid78 BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'VDI_32F9A7CC-3693-436B-AAF6-BA19A79A609A_0'. Operating system error 0x800705af(The paging file is too small for this operation to complete.).
Error is self explanatory, it...
June 5, 2012 at 1:04 pm
I would also include "Network Interface\Output Queue Length" since this is subscribed to 200 servers.
Due to network bottleneck, sometimes server cannot use other resources (CPU/MEMORY/IO) as expected and can lead...
June 5, 2012 at 11:41 am
Maybe you should read up on SQL Server Agent Alerts so you can see what they can do?
Here's a sample: http://msdn.microsoft.com/en-us/library/ms186385.aspx
Yes there are capabilities to setup various kind...
June 5, 2012 at 11:20 am
As far as I know, SQL server just gives free space information.
To know % free space we need to find something ouside of sql like perfmon, psinfo, wmi etc...
please correct...
June 5, 2012 at 10:51 am
thanks Gail bringing this to attention
June 5, 2012 at 9:19 am
Following will give you table/index with occupied data pages. Each datapage has 8k size.
select OBJECT_NAME(id) TableName,name,dpages,reserved,used from sys.sysindexes
June 5, 2012 at 9:05 am
There are different ways to monitor disk space and generate trend
1. xp_fixeddrives: gived you free space for all the drive
2. Sysinternal command prompt utility will give more information includes total...
June 5, 2012 at 8:50 am
There is no direct way, you need to create first version manually.
Then have DDL trigger setup and capture all DDL events in to a table.
Then you can append file...
June 4, 2012 at 2:12 pm
Yes I agree with Lynn Pettis, usually update statistics works fine. For specific issues you can use sql job.
June 4, 2012 at 11:07 am
Viewing 15 posts - 61 through 75 (of 113 total)