backup / trn file size.

I noticed recently that my data fike was quite large, and that the Log file
is even larger.
I have a 1.1 Gb Data file and a 12.8 Gb log file.
I noticed the grand sizes because of my backups, the bak file (done every 12
hours, grows by about 200mb every day. I am having a hard time believing my
400 odd users are pumping that much data in.
The Log and Data files are set to grow unrestricted, by 10% a go.
I have tried DBCC ShrinkFile and DBCC ShrinkDatabase, neither of which had
any effect on the DB size. My most recent attempt : DBCC SHRINKFile
(vmclean_log,20) gave me:
CurrentSize: 1634992
MinimumSize:128
UsedPages:1634992
Est Pages:128
I have 2 questions:
1) Recovery is set to full. Could I change this to Simple and be satisfied
that in event of failure I can recover my 12 hour backup and apply my 3 hour
Log backups to it to get back to the point of failure?
2) How can I find out what may be causing this?
Thanks
---
Duncan LoxtonDuncan
Have you tried to BACKUP LOG file before you issued DBCC SHRINKFILE.?
Look at DBCC LOGINFO(dbid) command to make sure you don't have transactions
with status=2 at the end of the list. This is causing to the LOG file not to
be shrinking.
"Duncan Loxton" <me@.privacy.com.au> wrote in message
news:2h31nmF7t7caU1@.uni-berlin.de...
> I noticed recently that my data fike was quite large, and that the Log
file
> is even larger.
> I have a 1.1 Gb Data file and a 12.8 Gb log file.
> I noticed the grand sizes because of my backups, the bak file (done every
12
> hours, grows by about 200mb every day. I am having a hard time believing
my
> 400 odd users are pumping that much data in.
> The Log and Data files are set to grow unrestricted, by 10% a go.
> I have tried DBCC ShrinkFile and DBCC ShrinkDatabase, neither of which had
> any effect on the DB size. My most recent attempt : DBCC SHRINKFile
> (vmclean_log,20) gave me:
> CurrentSize: 1634992
> MinimumSize:128
> UsedPages:1634992
> Est Pages:128
> I have 2 questions:
> 1) Recovery is set to full. Could I change this to Simple and be satisfied
> that in event of failure I can recover my 12 hour backup and apply my 3
hour
> Log backups to it to get back to the point of failure?
> 2) How can I find out what may be causing this?
> Thanks
> --
> ---
> Duncan Loxton
>|||Uri,
I checked Loginfo, and there are about 491 with status =2. I synched the
publication, and it still had the exact same number after the synch.
I just came across in BOLa reference to the Log Reader Agent. It looks like
this does the job of changing the status of pages that have been replicated.
I am running Merge Rep, but dont have a Log Reader Agent - should I have
one?
Surely these transactions with status =2 should be removed once the synch
has happened - but they arent..... What can I do?
Thanks!
duncan
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OtCFGfkPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> Duncan
> Have you tried to BACKUP LOG file before you issued DBCC SHRINKFILE.?
> Look at DBCC LOGINFO(dbid) command to make sure you don't have
transactions
> with status=2 at the end of the list. This is causing to the LOG file not
to
> be shrinking.
>
> "Duncan Loxton" <me@.privacy.com.au> wrote in message
> news:2h31nmF7t7caU1@.uni-berlin.de...
> file
every[vbcol=seagreen]
> 12
believing[vbcol=seagreen]
> my
had[vbcol=seagreen]
satisfied[vbcol=seagreen]
> hour
>|||Duncan
In order to move these transaction at the top of the list you have to
perform dummy insertion.
Create a table and with simple while...loop perfom an INSERT statement into
the table and then you will see that transction with status=2 is moved to
the top of the list.
"Duncan" <me@.privacy.com.au> wrote in message
news:2h4vn8F8v2ouU1@.uni-berlin.de...
> Uri,
> I checked Loginfo, and there are about 491 with status =2. I synched the
> publication, and it still had the exact same number after the synch.
> I just came across in BOLa reference to the Log Reader Agent. It looks
like
> this does the job of changing the status of pages that have been
replicated.
> I am running Merge Rep, but dont have a Log Reader Agent - should I have
> one?
> Surely these transactions with status =2 should be removed once the synch
> has happened - but they arent..... What can I do?
> Thanks!
> duncan
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OtCFGfkPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> transactions
not[vbcol=seagreen]
> to
> every
> believing
> had
> satisfied
3[vbcol=seagreen]
>