Welsh Corgi

Forum Replies Created

Viewing 15 posts - 916 through 930 (of 3,738 total)

RE: Log File Size does not shrink

Revenant (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/22/2014)
btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 4:00 pm

#1682962
RE: Log File Size does not shrink

GilaMonster (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/22/2014)
btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.
By going...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 3:28 pm

#1682958
RE: Log File Size does not shrink

GilaMonster (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/22/2014)
btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 3:16 pm

#1682955
RE: Log File Size does not shrink

GilaMonster (1/23/2014)
Welsh Corgi (1/23/2014)
GilaMonster (1/22/2014)
btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.
By going...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 2:56 pm

#1682951
RE: Log File Size does not shrink

GilaMonster (1/22/2014)
btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.
By going through the GUI...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 11:34 am

#1682887
RE: Log File Size does not shrink

Another command that was very useful in helping me understand what was going on was the following:
DBCC LogInfo
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 10:08 am

#1682863
RE: Log File Size does not shrink

I found the following command very useful as to what exactly preventing the log file from shrinking:
SELECT log_reuse_wait_desc, * FROM sys.databases
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2014 at 9:26 am

#1682848
RE: Log File Size does not shrink

GilaMonster (1/22/2014)
Welsh Corgi (1/22/2014)
Another backup, that log file has not changed in size.
No, it won't. Log backups do not shrink the file. Though, if it hasn't changed in size that...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 22, 2014 at 3:05 pm

#1682602
RE: Log File Size does not shrink

Another backup, that log file has not changed in size.
Next backup in 4 minutes.
Turned off shrinking.
I do not agree with shrinking either.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 22, 2014 at 8:25 am

#1682438
RE: Log File Size does not shrink

The Transaction Log File was backed up 3 minutes ago.
Right after the backup the transaction log file was over 5 GB.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 22, 2014 at 8:03 am

#1682424
RE: Log File Size does not shrink

GilaMonster (1/22/2014)
You shouldn't even be shrinking the log. If the log is growing, make the log backup more frequent or identify what is causing the log growth and resolve it.
btw,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 22, 2014 at 7:59 am

#1682419
RE: Log File Size does not shrink

Keith Tate (1/21/2014)
I would stop shrinking the log file. If you want to keep the size of the file smaller take your tlog backups more often than once an hour....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 22, 2014 at 6:46 am

#1682373
RE: Log File Size does not shrink

GilaMonster (1/21/2014)
What is the exact command you are using to backup the log (or if a maintenance plan, what are the exact options)?
The T-SQL Code from the Maintenance Plan is...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 22, 2014 at 6:42 am

#1682369
RE: Log File Size does not shrink

Keith Tate (1/21/2014)
LOG_BACKUP
I do not understand what is going on.
This means that it is waiting on a transaction log backup
If I do the backup in SQL Code how do I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 21, 2014 at 7:16 pm

#1682242
RE: SSIS password problem connecting to AS/400

bsantosh6 (1/21/2014)
Thanks Welsh Corgi!
Your post fixed my issue. (start up as local service)
Cool glad that worked for you.:cool:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 21, 2014 at 9:55 am

#1682076

Viewing 15 posts - 916 through 930 (of 3,738 total)