Groups > comp.databases.ms-sqlserver > #1345

Re: SIMPLE Recovery Model Log file growth

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!feeder2.ecngs.de!ecngs!feeder.ecngs.de!Xl.tags.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!local2.nntp.ams.giganews.com!nntp.bt.com!news.bt.com.POSTED!not-for-mail
NNTP-Posting-Date	Tue, 30 Oct 2012 16:43:21 -0500
From	"Cathy" <Cathy@Nospam.com>
Newsgroups	comp.databases.ms-sqlserver
References	<0tudnXZbkNzRyxHNnZ2dnUVZ7qednZ2d@bt.com> <XnsA0FA14761DAYazorman@127.0.0.1> <XMudnX_UdMRieBHNnZ2dnUVZ8hmdnZ2d@bt.com> <XnsA0FA6F96DC629Yazorman@127.0.0.1> <MN6dnd9uBcIkrBDNnZ2dnUVZ8uKdnZ2d@bt.com> <XnsA0FAA0E70E28EYazorman@127.0.0.1> <k6jnqa$rf3$1@dont-email.me> <17CdnaWZsLRDOBDNnZ2dnUVZ8s-dnZ2d@bt.com> <XnsA0FAEDAAB5AF1Yazorman@127.0.0.1>
In-Reply-To	<XnsA0FAEDAAB5AF1Yazorman@127.0.0.1>
Subject	Re: SIMPLE Recovery Model Log file growth
Date	Tue, 30 Oct 2012 21:43:18 -0000
MIME-Version	1.0
Content-Type	text/plain; format=flowed; charset="Windows-1252"; reply-type=original
Content-Transfer-Encoding	7bit
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE	Produced By Microsoft MimeOLE V6.0.6002.18463
Message-ID	<n7adnfO2cLRk1A3NnZ2dnUVZ8tWdnZ2d@bt.com> (permalink)
Lines	22
X-Usenet-Provider	http://www.giganews.com
X-AuthenticatedUsername	NoAuthUser
X-Trace	sv3-JWfPrwxMFPp1bZAR1p1zr0xinJpisI/B22CmiFgPYKgsW8TKYMoSYX8IMyfR59tpy4E7Jimv3NJ75kT!jwUFO8gEBR4NaFn7p1IvtAb+PHFbUY7exn4L7pbbQeo41sT1MVFCnHfFdDiTKonQtcwiI4xFudI3!1w==
X-Complaints-To	abuse@btinternet.com
X-DMCA-Complaints-To	abuse@btinternet.com
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Bytes	2190
Xref	csiph.com comp.databases.ms-sqlserver:1345

Show key headers only | View raw

Perhaps I am confusing the issue by providing too much details and getting 
things sidetracked

Lets forget about how many files there are and how many databases.

My question is as before

what is the simplest to
1. close any open transactions in the log file
2. take it offline if needed
3. Truncate it if needed
4. Shrink the database (sorry I realise my error now saying logfile before)
5. backup the database
6. bring the database online again

Imagine this is one database (whether simple of full recovery model)
I am hoping for a single TSQL Script I can use

regards

C

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-27 22:46 +0100
  Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 00:07 +0200
    Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-28 07:59 +0000
      Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 10:58 +0100
        Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-28 13:23 +0000
          Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 15:49 +0100
            Re: SIMPLE Recovery Model Log file growth "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-10-28 12:51 -0400
              Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-28 21:38 +0000
                Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 23:21 +0100
                Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-30 21:43 +0000
                Re: SIMPLE Recovery Model Log file growth "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-10-30 18:22 -0400
                Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-30 23:37 +0100

csiph-web