Is your log file set for autogrowth or restricted to some size?

what is your log file size when the error thrown

what is the log drive size and 15000 MB you...

MichaelDep (8/7/2013)

---

I am connectiing the sam way both on the server and from my workstation. I am using the virtual server name\instance name. When I cannot connect from...

This query will give you the file growth time, size and duration

Customize it as per your need and you have to have the trace file available on server for that...

+1 to jeff

Start->All programs->Microsoft SQL Server 2012-> SQL Server Management Studio

or

Start-> run-> SSMS

give sa and its password or through windows authentication if you have configured .

does NT AUTHORITY\NETWORK SERVICE has access to msdb with all sqlagent permissions.

To display structure sp_help 'table_name'

MichaelDep (8/7/2013)

---

I have two Windows 2012/SQL 2012 failover clusters that seem to go to sleep at night. I can connect to then with no issues all day long, but...

if you look at services in which account SQL Agent is running under?

greg.celentano (7/3/2013)

---

If you have production environment that is a fail over cluster is it a best practice to have your development environment be the same configuration for testing reasons? I...

if it is...

Does he want to track suspecting other users/team running the SP or not?

First one to find job schedule and second and UDF to give schedule details in proper format.

SELECT dbo.sysjobs.name, CAST(dbo.sysschedules.active_start_time / 10000 AS VARCHAR(10))

+ ':' + RIGHT('00' +...

Is it followed as per the below.

http://msdn.microsoft.com/en-us/library/ms345408(v=sql.100).aspx

Is it referring to proper path

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = 1

This is a 3 year old thread please dont post on this.