PFAW: Senator Bennet Caved to the Far Right by Returning his Blue Slip on Allison Eid FOR IMMEDIATE RELEASE: September 6, 2017 Contact: Courtney Neale at People For the American Way
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
As an example, if there is only 500MB of free space on the disc and you have a log file that is already say 8GB AND you have the autogrow set to grow by 10% then the file will try to grow 800MB which is more than the available disc space of 500MB. RE: can't set the log file to unrestricted growth. I've got an insert statement that keeps failing when I call it from a SQL 2005 stored procedure. After I try to call the stored procedure, I check the SQL logs for information. It tells me: Autogrow of file [dbname_log] in database [dbname] was cancelled by user or timed out after 407 miliseconds.