No announcements
Found 1803111 threads
-
0 Votesbest practices for handlding this database log file growth issue?
But I think there is was also to slow down the growth of log file by working on ur code.Answered | 6 Replies | 2228 Views | Created by tickermcse76 - Tuesday, June 4, 2013 12:10 PM | Last reply by Saurabh Sinha DBA - Tuesday, June 4, 2013 6:43 PM
-
5 Votes
Database log file growth
Please respond anyone with best sollution...Answered | 7 Replies | 7386 Views | Created by Chreddy S - Monday, September 12, 2011 10:33 AM | Last reply by srivatsanraju - Friday, September 30, 2011 6:32 AM -
0 Votes
Temp database and Temp log initial sizing and autosize increment best practices?
Does splitting the temp databases impact the size of the temp log file?Answered | 6 Replies | 2424 Views | Created by kimdav111 - Sunday, August 26, 2018 7:04 AM | Last reply by Shanky_621 - Monday, August 27, 2018 6:57 AM -
1 Votes
Control growth of the Database file
It is set to 1mb unrestricted growth and the log file is set to 400mb restricted growth.Answered | 6 Replies | 1378 Views | Created by doineedanid - Wednesday, October 7, 2015 2:02 PM | Last reply by doineedanid - Wednesday, October 21, 2015 2:53 PM -
0 Votes
Issue with Log file growth in Sql server 2008
The log file growth to 100GB or it don´t reduce?Answered | 12 Replies | 4719 Views | Created by Venkat Raju - Wednesday, September 14, 2011 1:59 PM | Last reply by Venkat Raju - Friday, September 16, 2011 10:18 AM -
1 Votes
Log file Growth query
In SQL Server, a log file specified with unlimited growth has a maximum size of 2 TB, and a data file has a maximum size of 16 TB.Answered | 5 Replies | 4157 Views | Created by Ven Raja - Tuesday, June 11, 2013 4:58 PM | Last reply by SoHelpMeCodd - Wednesday, September 3, 2014 7:03 PM -
4 Votes
SQL Log File Growth rate
Hi Humm, Seems that the log file growth rate of the database in B environment is set in %.Answered | 12 Replies | 1922 Views | Created by '''HuuM''' - Monday, December 2, 2013 3:27 PM | Last reply by Alankar Chakravorty - Monday, December 9, 2013 6:16 AM -
1 Votes
Mysterious transaction log file growth
Follow the process on the ...Answered | 4 Replies | 1933 Views | Created by Statistic - Tuesday, November 20, 2012 8:20 PM | Last reply by Statistic - Monday, December 3, 2012 7:48 PM -
1 Votes
file growth settings basics
It wont crash the system necessarily (Unless you have data and log files in the system drive(C) which again is a very bad practise ) but during the autogrowth process it is ...Answered | 7 Replies | 1073 Views | Created by cf090 - Tuesday, November 18, 2014 11:38 AM | Last reply by Ashwin Menon - Tuesday, November 18, 2014 12:20 PM -
0 Votes
how to design SQL server data file and log file growth
based on what we have to determine the ideal size of file auto growth.Answered | 2 Replies | 1416 Views | Created by Shivanq - Saturday, February 28, 2015 11:40 AM | Last reply by Kalman Toth - Saturday, February 28, 2015 2:46 PM -
0 Votes
best practice to mange config log file
Hi, i have schedule config database log backup daily once in night. link says take backup after 5-10 minutes, if i schedule log backup ...Answered | 2 Replies | 3694 Views | Created by imughal - Wednesday, February 8, 2012 5:21 AM | Last reply by imughal - Tuesday, February 14, 2012 5:10 AM -
1 Votes
AlwaysOn - changing log file growth setting
Using the same code I can see also that the file growth setting for the log file remains unchanged on the secondary.Answered | 9 Replies | 3477 Views | Created by SQL_Golfer - Wednesday, August 5, 2015 11:09 AM | Last reply by Shailesh_23 - Thursday, November 2, 2017 12:03 PM -
0 Votes
Database Growth
To start with check if database autogrowth is set to MB not percentage and value is not too high causing unnecessary data file growth.Answered | 7 Replies | 1829 Views | Created by VijayKSQL - Friday, September 13, 2019 12:09 AM | Last reply by SQLRockstar - Friday, September 20, 2019 11:50 PM -
0 Votes
OperationsManager db log file growth settings
How can I tell how much of the log file is actually being used?Answered | 4 Replies | 3318 Views | Created by tpullins - Tuesday, October 18, 2011 6:04 PM | Last reply by Michael Pearson - Tuesday, October 18, 2011 9:22 PM -
0 Votes
File growth size
Would it be best to run the following?Answered | 10 Replies | 1345 Views | Created by ti2 - Friday, November 29, 2013 1:28 PM | Last reply by ti2 - Tuesday, December 17, 2013 4:11 PM -
0 Votes
best practice move exchange 2007 database and logs
Just right click and move the DB and logs.Answered | 1 Replies | 4990 Views | Created by bluebark - Wednesday, September 22, 2010 5:20 PM | Last reply by Troy Werelius - Wednesday, September 22, 2010 5:57 PM -
1 Votes
Disable Transaction Log growth.
Logging is completely unnecessary, a waste of resources and a better designed database system would include an option to turn off logging.Answered | 5 Replies | 9137 Views | Created by -VB- - Monday, October 18, 2010 8:13 AM | Last reply by Corby Nichols - Wednesday, December 28, 2011 8:18 PM -
0 Votes
2 Log files for 1 database
Now after transaction completes disable autogrowth on file 2 to allow SQL Server to use File 1 This is not best practice but is in accordance ...Answered | 3 Replies | 1340 Views | Created by Andrea Caldarone - Monday, June 23, 2014 8:45 AM | Last reply by Shanky_621 - Monday, June 23, 2014 9:30 AM -
1 Votes
Database File Growth and Whitespace Usage
I currently have about 16GB of freespace on my primary Exchange database drive.Answered | 1 Replies | 4088 Views | Created by Ray Storer - Sunday, November 8, 2009 4:02 PM | Last reply by Rajnish R Sharma - Sunday, November 8, 2009 4:25 PM -
0 Votes
Suddenly Database growth is high
Is this data file size got increased or Log file ?Answered | 4 Replies | 2680 Views | Created by ESQL5 - Thursday, June 12, 2014 6:19 PM | Last reply by Ernest Ostrander - Thursday, June 12, 2014 9:27 PM - Items 1 to 20 of 1803111 Next ›
No announcements
