Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

MyPor1_SITE_log.LDF - 150 Gigabytes?

  Asked By: Harshita    Date: Jul 16    Category: Sharepoint    Views: 820

Small farm deployment - 1 SPS server and 1 SQL 2000 server.

Poking around SQL server today, I discover that:

MyPor1_SITE_log.LDF transaction log is 150 Gigabytes, which is quickly
eating up the
200 gig space allocated.

Why would it be so large in the first place?
More importantly, how can I reduce the size?

I researched this a little and one of the suggestions I found was to
swicth recovery method in SQL to Simple. However, I do not want to do
to do that, since also according to my resaerch, recovery method is
set from a master database, and I am sure that there is a good reason
why it is not setup in simple mode from the start.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Royce Orr     Answered On: Jul 16

I have worked with SharePoint and had numerous sites.. but never 150
Gigs...
how many sites do you have on there and docuements...do you have alot of
jpegs.???
or large files....???

Backup the sites with the SPS Backup and then to your switch recovery.

 
Answer #2    Answered By: Laura Walker     Answered On: Jul 16

That is the crazy part, I do not have many site, about 30. Site database
itself is only 3 gigs, but transaction log is at 150.

I look at the date stamp on all DB files and they point to a time of
maintenance, when both portal and db servers were rebooted after patches
were installed.


Around the same time (same minute, and the next 10 minutes)

I had about 30 errors

like

Event Type: Warning
Event Source: SharePoint Portal Server
Event Category: None
Event ID: 102
Date: 4/11/2006
Time: 9:02:06 PM
User: N/A
Computer: PORTAL
Description:
An error occurred while refreshing the portal application cache

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 44 00 A.p.p.D.


0240: 74 00 2e 00 50 00 6f 00 t...P.o.
0248: 72 00 74 00 61 00 6c 00 r.t.a.l.
0250: 2e 00 44 00 61 00 74 00 ..D.a.t.
0258: 61 00 2e 00 61 00 2e 00 a...a...
0260: 63 00 28 00 53 00 71 00 c.(.S.q.
0268: 6c 00 43 00 6f 00 6d 00 l.C.o.m.
0270: 6d 00 61 00 6e 00 64 00 m.a.n.d.
0278: 20 00 41 00 5f 00 30 00 .A._.0.
0280: 2c 00 20 00 42 00 6f 00 ,. .B.o.
0288: 6f 00 6c 00 65 00 61 00 o.l.e.a.
0290: 6e 00 20 00 41 00 5f 00 n. .A._.
0298: 31 00 29 00 0d 00 0a 00 1.).....
02a0: 20 00 20 00 20 00 61 00 . . .a.
02a8: 74 00 20 00 4d 00 69 00 t. .M.i.
02b0: 63 00 72 00 6f 00 73 00 c.r.o.s.
02b8: 6f 00 66 00 74 00 2e 00 o.f.t...
02c0: 53 00 68 00 61 00 72 00 S.h.a.r.
02c8: 65 00 50 00 6f 00 69 00 e.P.o.i.
02d0: 6e 00 74 00 2e 00 50 00 n.t...P.
02d8: 6f 00 72 00 74 00 61 00 o.r.t.a.
02e0: 6c 00 2e 00 44 00 61 00 l...D.a.
02e8: 74 00 61 00 2e 00 61 00 t.a...a.
02f0: 2e 00 62 00 28 00 53 00 ..b.(.S.
02f8: 71 00 6c 00 43 00 6f 00 q.l.C.o.
0300: 6d 00 6d 00 61 00 6e 00 m.m.a.n.
0308: 64 00 20 00 41 00 5f 00 d. .A._.
0310: 30 00 29 00 0d 00 0a 00 0.).....
0318: 20 00 20 00 20 00 61 00 . . .a.
0320: 74 00 20 00 4d 00 69 00 t. .M.i.
0328: 63 00 72 00 6f 00 73 00 c.r.o.s.
0330: 6f 00 66 00 74 00 2e 00 o.f.t...
0338: 53 00 68 00 61 00 72 00 S.h.a.r.
0340: 65 00 50 00 6f 00 69 00 e.P.o.i.
0348: 6e 00 74 00 2e 00 50 00 n.t...P.
0350: 6f 00 72 00 74 00 61 00 o.r.t.a.
0358: 6c 00 2e 00 44 00 61 00 l...D.a.
0360: 74 00 61 00 2e 00 61 00 t.a...a.
0368: 2e 00 62 00 28 00 53 00 ..b.(.S.
0370: 71 00 6c 00 43 00 6f 00 q.l.C.o.
0378: 6d 00 6d 00 61 00 6e 00 m.m.a.n.
0380: 64 00 20 00 41 00 5f 00 d. .A._.
0388: 30 00 29 00 0d 00 0a 00 0.).....
0390: 20 00 20 00 20 00 61 00 . . .a.
0398: 74 00 20 00 4d 00 69 00 t. .M.i.
03a0: 63 00 72 00 6f 00 73 00 c.r.o.s.
03a8: 6f 00 66 00 74 00 2e 00 o.f.t...
03b0: 53 00 68 00 61 00 72 00 S.h.a.r.
03b8: 65 00 50 00 6f 00 69 00 e.P.o.i.
03c0: 6e 00 74 00 2e 00 50 00 n.t...P.
03c8: 6f 00 72 00 74 00 61 00 o.r.t.a.
03d0: 6c 00 2e 00 54 00 6f 00 l...T.o.
03d8: 70 00 6f 00 6c 00 6f 00 p.o.l.o.
03e0: 67 00 79 00 2e 00 44 00 g.y...D.
03e8: 61 00 74 00 61 00 62 00 a.t.a.b.
03f0: 61 00 73 00 65 00 2e 00 a.s.e...
03f8: 61 00 28 00 61 00 20 00 a.(.a. .
0400: 41 00 5f 00 30 00 29 00 A._.0.).
0408: 0d 00 0a 00 20 00 20 00 .... . .
0410: 20 00 61 00 74 00 20 00 .a.t. .
0418: 4d 00 69 00 63 00 72 00 M.i.c.r.
0420: 6f 00 73 00 6f 00 66 00 o.s.o.f.
0428: 74 00 2e 00 53 00 68 00 t...S.h.
0430: 61 00 72 00 65 00 50 00 a.r.e.P.
0438: 6f 00 69 00 6e 00 74 00 o.i.n.t.
0440: 2e 00 50 00 6f 00 72 00 ..P.o.r.
0448: 74 00 61 00 6c 00 2e 00 t.a.l...
0450: 54 00 6f 00 70 00 6f 00 T.o.p.o.
0458: 6c 00 6f 00 67 00 79 00 l.o.g.y.
0460: 2e 00 43 00 6f 00 6e 00 ..C.o.n.
0468: 66 00 69 00 67 00 75 00 f.i.g.u.
0470: 72 00 61 00 74 00 69 00 r.a.t.i.
0478: 6f 00 6e 00 44 00 61 00 o.n.D.a.
0480: 74 00 61 00 62 00 61 00 t.a.b.a.
0488: 73 00 65 00 2e 00 67 00 s.e...g.
0490: 65 00 74 00 5f 00 44 00 e.t._.D.
0498: 61 00 74 00 61 00 62 00 a.t.a.b.
04a0: 61 00 73 00 65 00 56 00 a.s.e.V.
04a8: 65 00 72 00 73 00 69 00 e.r.s.i.
04b0: 6f 00 6e 00 28 00 29 00 o.n.(.).
04b8: 0d 00 0a 00 20 00 20 00 .... . .
04c0: 20 00 61 00 74 00 20 00 .a.t. .
04c8: 4d 00 69 00 63 00 72 00 M.i.c.r.
04d0: 6f 00 73 00 6f 00 66 00 o.s.o.f.
04d8: 74 00 2e 00 53 00 68 00 t...S.h.
04e0: 61 00 72 00 65 00 50 00 a.r.e.P.
04e8: 6f 00 69 00 6e 00 74 00 o.i.n.t.
04f0: 2e 00 50 00 6f 00 72 00 ..P.o.r.
04f8: 74 00 61 00 6c 00 2e 00 t.a.l...
0500: 61 00 6b 00 2e 00 67 00 a.k...g.
0508: 28 00 29 00 0d 00 0a 00 (.).....
0510: 20 00 20 00 20 00 61 00 . . .a.
0518: 74 00 20 00 4d 00 69 00 t. .M.i.
0520: 63 00 72 00 6f 00 73 00 c.r.o.s.
0528: 6f 00 66 00 74 00 2e 00 o.f.t...
0530: 53 00 68 00 61 00 72 00 S.h.a.r.
0538: 65 00 50 00 6f 00 69 00 e.P.o.i.
0540: 6e 00 74 00 2e 00 50 00 n.t...P.
0548: 6f 00 72 00 74 00 61 00 o.r.t.a.
0550: 6c 00 2e 00 50 00 6f 00 l...P.o.
0558: 72 00 74 00 61 00 6c 00 r.t.a.l.
0560: 41 00 70 00 70 00 6c 00 A.p.p.l.
0568: 69 00 63 00 61 00 74 00 i.c.a.t.
0570: 69 00 6f 00 6e 00 2e 00 i.o.n...
0578: 52 00 65 00 66 00 72 00 R.e.f.r.
0580: 65 00 73 00 68 00 28 00 e.s.h.(.
0588: 29 00 0d 00 0a 00 20 00 )..... .
0590: 20 00 20 00 61 00 74 00 . .a.t.
0598: 20 00 4d 00 69 00 63 00 .M.i.c.
05a0: 72 00 6f 00 73 00 6f 00 r.o.s.o.
05a8: 66 00 74 00 2e 00 53 00 f.t...S.
05b0: 68 00 61 00 72 00 65 00 h.a.r.e.
05b8: 50 00 6f 00 69 00 6e 00 P.o.i.n.
05c0: 74 00 2e 00 50 00 6f 00 t...P.o.
05c8: 72 00 74 00 61 00 6c 00 r.t.a.l.
05d0: 2e 00 50 00 6f 00 72 00 ..P.o.r.
05d8: 74 00 61 00 6c 00 41 00 t.a.l.A.
05e0: 70 00 70 00 6c 00 69 00 p.p.l.i.
05e8: 63 00 61 00 74 00 69 00 c.a.t.i.
05f0: 6f 00 6e 00 2e 00 61 00 o.n...a.
05f8: 28 00 4f 00 62 00 6a 00 (.O.b.j.
0600: 65 00 63 00 74 00 20 00 e.c.t. .
0608: 41 00 5f 00 30 00 29 00 A._.0.).
and


Event Type: Error
Event Source: Windows SharePoint Services 2.0
Event Category: None
Event ID: 1000
Date: 4/11/2006
Time: 9:11:14 PM
User: N/A
Computer: PORTAL
Description:
#50070: Unable to connect to the database SPS01_Config_db on DBSERVER.
Check the database connection information and make sure that the database
server is running.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp.
and


Event Type: Error
Event Source: SharePoint Portal Administration Service
Event Category: None
Event ID: 202
Date: 4/11/2006
Time: 9:10:58 PM
User: N/A
Computer: PORTAL

Description:
Synchronization exception occurred

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp." target="_blank" rel="nofollow">http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 44 00 A.p.p.D.
0008: 6f 00 6d 00 61 00 69 00 o.m.a.i.
0010: 6e 00 3a 00 20 00 73 00 n.:. .s.
0018: 70 00 73 00 61 00 64 00 p.s.a.d.
0020: 6d 00 69 00 6e 00 2e 00 m.i.n...
0028: 65 00 78 00 65 00 0d 00 e.x.e...
0030: 0a 00 53 00 79 00 73 00 ..S.y.s.
0038: 74 00 65 00 6d 00 2e 00 t.e.m...
0040: 44 00 61 00 74 00 61 00 D.a.t.a.
0048: 2e 00 53 00 71 00 6c 00 ..S.q.l.
0050: 43 00 6c 00 69 00 65 00 C.l.i.e.
0058: 6e 00 74 00 2e 00 53 00 n.t...S.
0060: 71 00 6c 00 45 00 78 00 q.l.E.x.
0068: 63 00 65 00 70 00 74 00 c.e.p.t.
0070: 69 00 6f 00 6e 00 3a 00 i.o.n.:.
0078: 20 00 53 00 79 00 73 00 .S.y.s.
0080: 74 00 65 00 6d 00 2e 00 t.e.m...
0088: 44 00 61 00 74 00 61 00 D.a.t.a.
0090: 2e 00 53 00 71 00 6c 00 ..S.q.l.
0098: 43 00 6c 00 69 00 65 00 C.l.i.e.
00a0: 6e 00 74 00 2e 00 53 00 n.t...S.
00a8: 71 00 6c 00 45 00 78 00 q.l.E.x.
00b0: 63 00 65 00 70 00 74 00 c.e.p.t.
00b8: 69 00 6f 00 6e 00 3a 00 i.o.n.:.
00c0: 20 00 54 00 69 00 6d 00 .T.i.m.
00c8: 65 00 6f 00 75 00 74 00 e.o.u.t.
00d0: 20 00 65 00 78 00 70 00 .e.x.p.
00d8: 69 00 72 00 65 00 64 00 i.r.e.d.
00e0: 2e 00 20 00 20 00 54 00 .. . .T.
00e8: 68 00 65 00 20 00 74 00 h.e. .t.
00f0: 69 00 6d 00 65 00 6f 00 i.m.e.o.
00f8: 75 00 74 00 20 00 70 00 u.t. .p.
0100: 65 00 72 00 69 00 6f 00 e.r.i.o.
0108: 64 00 20 00 65 00 6c 00 d. .e.l.
0110: 61 00 70 00 73 00 65 00 a.p.s.e.
0118: 64 00 20 00 70 00 72 00 d. .p.r.
0120: 69 00 6f 00 72 00 20 00 i.o.r. .
0128: 74 00 6f 00 20 00 63 00 t.o. .c.
0130: 6f 00 6d 00 70 00 6c 00 o.m.p.l.
0138: 65 00 74 00 69 00 6f 00 e.t.i.o.
0140: 6e 00 20 00 6f 00 66 00 n. .o.f.
0148: 20 00 74 00 68 00 65 00 .t.h.e.
0150: 20 00 6f 00 70 00 65 00 .o.p.e.
0158: 72 00 61 00 74 00 69 00 r.a.t.i.
0160: 6f 00 6e 00 20 00 6f 00 o.n. .o.
0168: 72 00 20 00 74 00 68 00 r. .t.h.
0170: 65 00 20 00 73 00 65 00 e. .s.e.
0178: 72 00 76 00 65 00 72 00 r.v.e.r.
0180: 20 00 69 00 73 00 20 00 .i.s. .
0188: 6e 00 6f 00 74 00 20 00 n.o.t. .
0190: 72 00 65 00 73 00 70 00 r.e.s.p.
0198: 6f 00 6e 00 64 00 69 00 o.n.d.i.
01a0: 6e 00 67 00 2e 00 0d 00 n.g.....
01a8: 0a 00 20 00 20 00 20 00 .. . . .
01b0: 61 00 74 00 20 00 4d 00 a.t. .M.
01b8: 69 00 63 00 72 00 6f 00 i.c.r.o.
01c0: 73 00 6f 00 66 00 74 00 s.o.f.t.
01c8: 2e 00 53 00 68 00 61 00 ..S.h.a.
01d0: 72 00 65 00 50 00 6f 00 r.e.P.o.
01d8: 69 00 6e 00 74 00 2e 00 i.n.t...
01e0: 50 00 6f 00 72 00 74 00 P.o.r.t.
01e8: 61 00 6c 00 2e 00 44 00 a.l...D.
01f0: 61 00 74 00 61 00 2e 00 a.t.a...
01f8: 61 00 2e 00 63 00 28 00 a...c.(.
0200: 29 00 0d 00 0a 00 20 00 )..... .
0208: 20 00 20 00 61 00 74 00 . .a.t.
0210: 20 00 4d 00 69 00 63 00 .M.i.c.
0218: 72 00 6f 00 73 00 6f 00 r.o.s.o.
0220: 66 00 74 00 2e 00 53 00 f.t...S.
0228: 68 00 61 00 72 00 65 00 h.a.r.e.
0230: 50 00 6f 00 69 00 6e 00 P.o.i.n.
0238: 74 00 2e 00 50 00 6f 00 t...P.o.
0240: 72 00 74 00 61 00 6c 00 r.t.a.l.
0248: 2e 00 44 00 61 00 74 00 ..D.a.t.
0250: 61 00 2e 00 61 00 2e 00 a...a...
0258: 63 00 28 00 29 00 0d 00 c.(.)...
0260: 0a 00 20 00 20 00 20 00 .. . . .
0268: 61 00 74 00 20 00 4d 00 a.t. .M.
0270: 69 00 63 00 72 00 6f 00 i.c.r.o.
0278: 73 00 6f 00 66 00 74 00 s.o.f.t.
0280: 2e 00 53 00 68 00 61 00 ..S.h.a.
0288: 72 00 65 00 50 00 6f 00 r.e.P.o.
0290: 69 00 6e 00 74 00 2e 00 i.n.t...
0298: 50 00 6f 00 72 00 74 00 P.o.r.t.
02a0: 61 00 6c 00 2e 00 44 00 a.l...D.
02a8: 61 00 74 00 61 00 2e 00 a.t.a...
02b0: 61 00 2e 00 63 00 28 00 a...c.(.
02b8: 53 00 71 00 6c 00 43 00 S.q.l.C.
02c0: 6f 00 6d 00 6d 00 61 00 o.m.m.a.
02c8: 6e 00 64 00 20 00 41 00 n.d. .A.
02d0: 5f 00 30 00 2c 00 20 00 _.0.,. .
02d8: 42 00 6f 00 6f 00 6c 00 B.o.o.l.
02e0: 65 00 61 00 6e 00 20 00 e.a.n. .
02e8: 41 00 5f 00 31 00 29 00 A._.1.).
02f0: 0d 00 0a 00 20 00 20 00 .... . .
02f8: 20 00 61 00 74 00 20 00 .a.t. .
0300: 4d 00 69 00 63 00 72 00 M.i.c.r.
0308: 6f 00 73 00 6f 00 66 00 o.s.o.f.
0310: 74 00 2e 00 53 00 68 00 t...S.h.
0318: 61 00 72 00 65 00 50 00 a.r.e.P.
0320: 6f 00 69 00 6e 00 74 00 o.i.n.t.
0328: 2e 00 50 00 6f 00 72 00 ..P.o.r.
0330: 74 00 61 00 6c 00 2e 00 t.a.l...
0338: 44 00 61 00 74 00 61 00 D.a.t.a.
0340: 2e 00 61 00 2e 00 63 00 ..a...c.
0348: 28 00 53 00 71 00 6c 00 (.S.q.l.
0350: 43 00 6f 00 6d 00 6d 00 C.o.m.m.
0358: 61 00 6e 00 64 00 20 00 a.n.d. .
0360: 41 00 5f 00 30 00 2c 00 A._.0.,.
0368: 20 00 42 00 6f 00 6f 00 .B.o.o.
0370: 6c 00 65 00 61 00 6e 00 l.e.a.n.
0378: 20 00 41 00 5f 00 31 00 .A._.1.
0380: 29 00 0d 00 0a 00 20 00 )..... .
0388: 20 00 20 00 61 00 74 00 . .a.t.
0390: 20 00 4d 00 69 00 63 00 .M.i.c.
0398: 72 00 6f 00 73 00 6f 00 r.o.s.o.
03a0: 66 00 74 00 2e 00 53 00 f.t...S.
03a8: 68 00 61 00 72 00 65 00 h.a.r.e.
03b0: 50 00 6f 00 69 00 6e 00 P.o.i.n.
03b8: 74 00 2e 00 50 00 6f 00 t...P.o.
03c0: 72 00 74 00 61 00 6c 00 r.t.a.l.
03c8: 2e 00 44 00 61 00 74 00 ..D.a.t.
03d0: 61 00 2e 00 61 00 2e 00 a...a...
03d8: 62 00 28 00 53 00 71 00 b.(.S.q.
03e0: 6c 00 43 00 6f 00 6d 00 l.C.o.m.
03e8: 6d 00 61 00 6e 00 64 00 m.a.n.d.
03f0: 20 00 41 00 5f 00 30 00 .A._.0.
03f8: 29 00 0d 00 0a 00 20 00 )..... .
0400: 20 00 20 00 61 00 74 00 . .a.t.
0408: 20 00 4d 00 69 00 63 00 .M.i.c.
0410: 72 00 6f 00 73 00 6f 00 r.o.s.o.
0418: 66 00 74 00 2e 00 53 00 f.t...S.
0420: 68 00 61 00 72 00 65 00 h.a.r.e.
0428: 50 00 6f 00 69 00 6e 00 P.o.i.n.
0430: 74 00 2e 00 50 00 6f 00 t...P.o.
0438: 72 00 74 00 61 00 6c 00 r.t.a.l.
0440: 2e 00 44 00 61 00 74 00 ..D.a.t.
0448: 61 00 2e 00 61 00 2e 00 a...a...
0450: 62 00 28 00 53 00 71 00 b.(.S.q.
0458: 6c 00 43 00 6f 00 6d 00 l.C.o.m.
0460: 6d 00 61 00 6e 00 64 00 m.a.n.d.
0468: 20 00 41 00 5f 00 30 00 .A._.0.
0470: 29 00 0d 00 0a 00 20 00 )..... .
0478: 20 00 20 00 61 00 74 00 . .a.t.
0480: 20 00 4d 00 69 00 63 00 .M.i.c.
0488: 72 00 6f 00 73 00 6f 00 r.o.s.o.
0490: 66 00 74 00 2e 00 53 00 f.t...S.
0498: 68 00 61 00 72 00 65 00 h.a.r.e.
04a0: 50 00 6f 00 69 00 6e 00 P.o.i.n.
04a8: 74 00 2e 00 50 00 6f 00 t...P.o.
04b0: 72 00 74 00 61 00 6c 00 r.t.a.l.
04b8: 2e 00 54 00 6f 00 70 00 ..T.o.p.
04c0: 6f 00 6c 00 6f 00 67 00 o.l.o.g.
04c8: 79 00 2e 00 44 00 61 00 y...D.a.
04d0: 74 00 61 00 62 00 61 00 t.a.b.a.
04d8: 73 00 65 00 2e 00 61 00 s.e...a.
04e0: 28 00 61 00 20 00 41 00 (.a. .A.
04e8: 5f 00 30 00 29 00 0d 00 _.0.)...
04f0: 0a 00 20 00 20 00 20 00 .. . . .
04f8: 61 00 74 00 20 00 4d 00 a.t. .M.
0500: 69 00 63 00 72 00 6f 00 i.c.r.o.
0508: 73 00 6f 00 66 00 74 00 s.o.f.t.
0510: 2e 00 53 00 68 00 61 00 ..S.h.a.
0518: 72 00 65 00 50 00 6f 00 r.e.P.o.
0520: 69 00 6e 00 74 00 2e 00 i.n.t...
0528: 50 00 6f 00 72 00 74 00 P.o.r.t.
0530: 61 00 6c 00 2e 00 54 00 a.l...T.
0538: 6f 00 70 00 6f 00 6c 00 o.p.o.l.
0540: 6f 00 67 00 79 00 2e 00 o.g.y...
0548: 43 00 6f 00 6e 00 66 00 C.o.n.f.
0550: 69 00 67 00 75 00 72 00 i.g.u.r.
0558: 61 00 74 00 69 00 6f 00 a.t.i.o.
0560: 6e 00 44 00 61 00 74 00 n.D.a.t.
0568: 61 00 62 00 61 00 73 00 a.b.a.s.
0570: 65 00 2e 00 67 00 65 00 e...g.e.
0578: 74 00 5f 00 44 00 61 00 t._.D.a.
0580: 74 00 61 00 62 00 61 00 t.a.b.a.
0588: 73 00 65 00 56 00 65 00 s.e.V.e.
0590: 72 00 73 00 69 00 6f 00 r.s.i.o.
0598: 6e 00 28 00 29 00 0d 00 n.(.)...
05a0: 0a 00 20 00 20 00 20 00 .. . . .
05a8: 61 00 74 00 20 00 4d 00 a.t. .M.
05b0: 69 00 63 00 72 00 6f 00 i.c.r.o.
05b8: 73 00 6f 00 66 00 74 00 s.o.f.t.
05c0: 2e 00 53 00 68 00 61 00 ..S.h.a.
05c8: 72 00 65 00 50 00 6f 00 r.e.P.o.
05d0: 69 00 6e 00 74 00 2e 00 i.n.t...
05d8: 50 00 6f 00 72 00 74 00 P.o.r.t.
05e0: 61 00 6c 00 2e 00 41 00 a.l...A.
05e8: 64 00 6d 00 69 00 6e 00 d.m.i.n.
05f0: 69 00 73 00 74 00 72 00 i.s.t.r.
05f8: 61 00 74 00 69 00 6f 00 a.t.i.o.
0600: 6e 00 53 00 65 00 72 00 n.S.e.r.
0608: 76 00 69 00 63 00 65 00 v.i.c.e.
0610: 2e 00 52 00 75 00 6e 00 ..R.u.n.
0618: 28 00 29 00 (.).

So, looks like when servers were rebooted they did not catch up with each
other, and perhaps SQL tried to rebuild databases?? and went for a crazy
loop of sorts??

I don't know... I am not a DBA.

I guess at this point all I care for is to reduce the size of that
transaction log. But do it the right way so that my portal does not suffer.
Does any one have a procedure that I can follow, please?

 
Didn't find what you were looking for? Find more on MyPor1_SITE_log.LDF - 150 Gigabytes? Or get search suggestion and latest updates.




Tagged: