Lynn Pettis (8/7/2015)

Please tell me you aren't updating statistics...

Every situation is different, but this is the order of my backup jobs:

1. Reorganize/Rebuild index

2. Check integrity

3. Update Statistics

4. Backup database.

Maybe this will help.

I added a step in my database backup jobs that reorganizes if fragmentation is between 10-30% rebuilds if over 30%. Also, object is a user table, big...

Michael L John

I should have been more specific that this is a one time process for wrangling in unmanaged transaction log VLF's. Still, don't call it "Mis-information" unless you are...

I'm using this code which is a hodge podge of scripts I've found and my own twists.

Maybe you can modify it for your needs.

DECLARE @command VARCHAR(4000)

DECLARE @schemaname VARCHAR(130)

DECLARE @objectname...

Hope this helps a bit.

http://sqlserverperformance.wordpress.com/2010/06/22/detecting-and-reducing-vlfs-in-sql-server-20082008-r2-transaction-log-files/

http://www.sqlservercentral.com/articles/Administration/64582/

Step 1 == > Check VLF Count using DBCC LogInfo

Step 2 ==> Backup the Transaction Log

Step 3 == >...

Thanks,

We have up to v4.0.30319 installed on that server.

v2.0.50727

v3.0

v3.5

v4.0.30319

2008 using the framework for the geography types.

I'm getting errors when I try to dbcc checkdb on a database with...

Using Hyper-V Dynamic Memory?

- Check VLF Count using DBCC LogInfo (excessive VLF's will cause performance issues)

- Put the database in full recovery

- Backup the transaction log

BACKUP LOG @databasename TO DISK = @filename...

Does the caller have permissions on both databases? Try adding a with execute to the trigger and see if it runs.

CREATE PROCEDURE dbo.usp_Demo

WITH EXECUTE AS 'SqlUserWithPermissionsInBothDBs'

🙂 I'm glad you were able to use it. I was in a rush and not able to customize it, but I figured you'd get the idea.

You could just create another monitor job that queries job history every three hours and sends an alert.

use msdb

go

SELECT j.[name], h.step_id, h.step_name, h.[message],

h.run_status, h.run_date, h.run_time, h.run_duration

FROM sysjobs j

LEFT JOIN sysjobhistory...

CREATE TABLE [dbo].[QA_dbSizeSnapshot](

[rowId] [int] IDENTITY(1,1) NOT NULL,

[dbName] [varchar(255) NOT NULL,

[dataFileSizeMB] [float] NOT NULL,

[logFileSizeMB] [float] NOT NULL,

[capturedDtg] [datetime] NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[QA_dbSizeSnapshot] ADD CONSTRAINT [DF_QA_dbSizeSnapshot_capturedDtg] DEFAULT (getdate()) for [capturedDTG]

GO

/******Job...

Are you able to look at the job under Management Studio/sql server agent/jobs?

-Management Studio/sql server agent/jobs

-Double click the job

-select "steps" from the left window

-double click a step

Could it have more...

Thanks for your reply!

I've looked at the error log/job history and there are no entries for +-5 mins around the time of the grow. Also, everything that should have run...