There is no need to worry about the 5pm log backup if you just took a Full backup later. You will have all the data that you need in the...

Absolutely not, your Server Account should only be User level permission account. There is no need to grant admin level permission to a service account.

You must install the application using...

No, I do not perform maintenance plans. I write the code by hand.

But in any case, nothing else in creating any backups of any type.

Andrew SQLDBA

You may try to shrink the database. I use this only when necessary.

You may also try DBCC SHRINKFILE with the TRUNCATEONLY attribute. Read the SQL BOL for the exact syntax...

There is approx 17 Gigs in these 4 tables.

dbo syscollector_blobs_internal 1 960 952 8 0

dbo sysmail_attachments 18 4080 4064 8 8

dbo sysssispackages 21 9640 9616 24 0

dbo sysjobhistory 1000 3384...

OK, this script will give you a row count per table: Lets see what table(s) may be causing this.

USE MSDB

SELECT

a3.name AS [schemaname],

a2.name...

Run this query

And show the results

SELECT

type_desc AS FileType

,name AS DatabaseName

,size AS DatabaseSize

, size/1024 AS MBSize

,physical_name

FROM

master.sys.master_files

WHERE

name LIKE 'msdb%'

ORDER BY

name ASC

Andrew SQLDBA

That is actually about normal.

Are you sure this is the size of the Data file, and not the Log file? Look on the drive, and see what one is the...

Do you have an abnormally huge number of SSIS packages?

Preform a Full backup, and that should truncate the log file for you.

How often do you take a Full backup of...

That is it. There is your problem. The openquery is not getting any recordset from what ever it is trying to select data from. And in turn, not populating any...

What user account are you using for the SQL job?

Have you looked at the job history? Have you looked at the SQL logs? Is there a USE statement at the...

That is because there is still a user connected to that database.

Change the default database that *You* are logging into SSMS with, and then log back into SQL. Verify that...

Yes, I think it is really Great. I would have never thought to use it, that is why I asked on here.

Very nice script

Thank You again

Andrew SQLDBA

Scott

Thank you very much, this is exactly what I was looking for.

Andrew SQLDBA

Thanks Greatly

That is perfect

Andrew SQLDBA