MRManthani
asked on
how to fix particular size for the error log file
how to fix particular size for the error log file
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
My error log file size is increasing ....i want to set a fixed size to the log files ,so that when it reaches that size,it shoud automatically create a new log file with out the system to be restarted
the article describes it. By the way what is sql server version?
ASKER
2005
ASKER
other tha using EXEC master.sys.sp_cycle_errorl
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
you can restrict the log file size and number which is defined in the article in detail...
tigin: can you clarify for me, please, where you control the (max) SIZE for the error log file(s) ?
I could not find that...
I could not find that...
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://www.mssqltips.com/tip.asp?tip=1155