tag:blogger.com,1999:blog-8639620768047672710.post6911382356230474411..comments2022-11-16T03:59:50.723-08:00Comments on SQL Server 2008: SQL Server 2008 - Truncating Transaction LogMadhu K Nairhttp://www.blogger.com/profile/08936146465563191414noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8639620768047672710.post-85359090225028899012009-11-21T07:17:33.804-08:002009-11-21T07:17:33.804-08:00I think you can also shrink the log by doing a tra...I think you can also shrink the log by doing a transaction log backup. (No need to change recovery mode.)<br /><br />You then have the choice of either keeping the TLOG backup in case you want to restore it for point in time restores beyond your last full backup, or to recover transactions since your last full backup in the event of losing your main mdf file due to a problem.<br /><br />For this last reason I think an hourly backup schedule is recommended for the TLOG.Matthttps://www.blogger.com/profile/04443175614508790849noreply@blogger.comtag:blogger.com,1999:blog-8639620768047672710.post-75161517732322871602009-11-14T19:51:28.178-08:002009-11-14T19:51:28.178-08:00@Carolina.
Of course you should change your Recov...@Carolina. <br />Of course you should change your Recovery model to FULL. Otherwise, point intime restore will not be available for the db.Madhu K Nairhttps://www.blogger.com/profile/08936146465563191414noreply@blogger.comtag:blogger.com,1999:blog-8639620768047672710.post-42188928289187647502009-11-13T10:12:50.758-08:002009-11-13T10:12:50.758-08:00And after the database is shrinked, do I have to t...And after the database is shrinked, do I have to take back the Recovery Model to Full???Unknownhttps://www.blogger.com/profile/16557164800847501689noreply@blogger.comtag:blogger.com,1999:blog-8639620768047672710.post-64272064401981534932009-03-17T16:54:00.000-07:002009-03-17T16:54:00.000-07:00Your file_id is incorrect, its is probably 2, not ...Your file_id is incorrect, its is probably 2, not 1.Chetanhttps://www.blogger.com/profile/11833333900004144898noreply@blogger.comtag:blogger.com,1999:blog-8639620768047672710.post-92155861017363552302008-11-05T16:47:00.000-08:002008-11-05T16:47:00.000-08:00Try a log backup, TWICE, then shrink. I read some...Try a log backup, TWICE, then shrink. I read somewhere there is a bug.Unknownhttps://www.blogger.com/profile/15244487836474074248noreply@blogger.com