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
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...
> 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[vbcol=seagreen]
> 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
> 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.[vbcol=seagreen]
> 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment