Rich, I am NO expert with SQL at all, but a couple of years ago I had similar issues.I followed this advice and it seemed to do the trick.I bookmarked it for future reference.Don't know if it will help you or not, but worth a look. http://www.techrepublic.com/blog/the-enterprise-cloud/help-my-sql-server-log-file-is-too-big/ Best wishes, Verner tHe LiTtLe YeLlOw DaFfOdIl @}-,-'-- From: Richard Naef <[email protected]> To: leeds list <[email protected]> Sent: Wednesday, 14 October 2015, 10:23 Subject: [LU] NONLU: MSSQLServer experts advice please. Hi,
I have an SQL DB with an enormous log file. I have changed the Recovery Model from Full to Simple, but now need to shrink the file itself - advice on line is a bit conflicting so I'd appreciate any advice. ttfn Richard _______________________________________________ Leedslist mailing list Info and options: http://mailman.greennet.org.uk/mailman/listinfo/leedslist To unsubscribe, email [email protected] MARCHING ON TOGETHER _______________________________________________ Leedslist mailing list Info and options: http://mailman.greennet.org.uk/mailman/listinfo/leedslist To unsubscribe, email [email protected] MARCHING ON TOGETHER
