SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Strange issue with one of the four Sharepoint databases that we Log ship to our DR site.


Strange issue with one of the four Sharepoint databases that we Log ship to our DR site.

Author
Message
mcdba@russweb.co.uk
mcdba@russweb.co.uk
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 224
On the server that hosts our Sharepoint databases we are log shipping 4 of them to a sql server instance at our DR site. The issue we are seeing is that for one of the 4 databases the first transaction log generated by the Log Shipping scheduled task after the full backup has been taken is the same size as the database itself (2.4Gb). Following this all subsquent files genrated are much smaller (200 Mb).

I have checked for open / long running transactions but none are reported.

Out of the 4 Sharepoint databases the one with the issue is the only one that has any Sharepoint Workflows configured. However they are configured to run in response to actions rather than at a certain time of day.

Both Servers are SQL Server 2008 SP3 Standard 64 bit.

Has anyone got any thoughts on what might be causing this behavoiur.



AJ@SQL
AJ@SQL
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 309
Have you checked this multiple times, are the results same all the time?
There would be transactions/ changes that were in progress when you took the backup and needs to be backed up.
What happens when you take another FULL backup and a Tlog backup following that?

To dig further, you may want to use "RESTORE HEADER ONLY" for the backup taken and review the DatabaseBackupLSN and CHECKPOINTLSN. This might give you a hint for why the LOG Backup is big.

Can also get the similar details from: "msdb..backupset"

Reviewing the above for both backup sets can provide more clarity.
mcdba@russweb.co.uk
mcdba@russweb.co.uk
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 224
After investigating further it seems to not be related to when a full backup is taken. It seems to be something to do with either the index optimisation scripts we run, or the fact that the Sharepoint workflows seem to insert a lot of rows into the EventCache table between midnight and 2am.



AJ@SQL
AJ@SQL
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 309
Thanks for the update!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search