Click here to Skip to main content
15,917,059 members
Home / Discussions / Database
   

Database

 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:07
Azam Niaz Ch.1-Jun-15 0:07 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:15
professionalKornfeld Eliyahu Peter1-Jun-15 0:15 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:26
Azam Niaz Ch.1-Jun-15 0:26 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:49
professionalKornfeld Eliyahu Peter1-Jun-15 0:49 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:29
Azam Niaz Ch.1-Jun-15 1:29 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 1:39
professionalKornfeld Eliyahu Peter1-Jun-15 1:39 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:50
Azam Niaz Ch.1-Jun-15 1:50 
AnswerRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 2:09
professionalKornfeld Eliyahu Peter1-Jun-15 2:09 
TRUNCATE_ONLY option does not reorganize the file but try to free the empty block at the end of the log file...It is possible that without page-reorganization there is no actual space to free...
Instead of TRUNCATE_ONLY use tager_size...
SQL
DBCC SHRINKFILE('your-log-file', 200) -- for 200 MB

It will take much more time as SQL will try to reorganize pages inside the log file and drop them if marked properly by the backup process...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.

GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 2:17
Azam Niaz Ch.1-Jun-15 2:17 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 2:18
professionalKornfeld Eliyahu Peter1-Jun-15 2:18 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 2:53
Azam Niaz Ch.1-Jun-15 2:53 
AnswerRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 3:19
professionalKornfeld Eliyahu Peter1-Jun-15 3:19 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 19:36
Azam Niaz Ch.1-Jun-15 19:36 
GeneralRe: LDF file Size is so increased Pin
Corporal Agarn2-Jun-15 1:34
professionalCorporal Agarn2-Jun-15 1:34 
GeneralRe: LDF file Size is so increased Pin
GuyThiebaut4-Jun-15 2:08
professionalGuyThiebaut4-Jun-15 2:08 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.4-Jun-15 7:26
Azam Niaz Ch.4-Jun-15 7:26 
GeneralRe: LDF file Size is so increased Pin
GuyThiebaut4-Jun-15 7:28
professionalGuyThiebaut4-Jun-15 7:28 
GeneralRe: LDF file Size is so increased Pin
Richard Deeming4-Jun-15 8:44
mveRichard Deeming4-Jun-15 8:44 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.5-Jun-15 20:40
Azam Niaz Ch.5-Jun-15 20:40 
GeneralRe: LDF file Size is so increased Pin
Richard Deeming7-Jun-15 21:27
mveRichard Deeming7-Jun-15 21:27 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.21-Jun-15 9:04
Azam Niaz Ch.21-Jun-15 9:04 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.4-Jun-15 7:29
Azam Niaz Ch.4-Jun-15 7:29 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.4-Jun-15 8:30
Azam Niaz Ch.4-Jun-15 8:30 
QuestionSQL: Function To find Last business day of the Month factoring in Holidays Pin
swoozie128-May-15 7:43
swoozie128-May-15 7:43 
AnswerRe: SQL: Function To find Last business day of the Month factoring in Holidays Pin
Eddy Vluggen29-May-15 2:35
professionalEddy Vluggen29-May-15 2:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.