How To Change The Transaction Log File Size To Less Than The Intial Setting.
I have H Drive with 12 GB size. The Transaction log file of my Database is given in H drive. i.e H:san_log.LDF.My database initial setting for the san_log.LDF is 10 GB.so currently I can see 10 gb file occupied in the H Drive.very soon my database san_log.LDF is going to increase 10%.Even though If do Backup/Shrink, it will reduce to the initial to 10 GB. So all I need is, change the initial size of the san_log.LDF from 10 GB to 5 GB.Pls give your suggetions .Thanx in advance.Regards,Sanjeev
March 23rd, 2010 12:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics