This is inaccurate (at least for 2005/2008). SQL Server's default trace file records this information. As a test, run something similar to USE [MyDB]

GO

DBCC SHRINKFILE (N'MyDB_log' , 2048)

GO

...

Of course, I agree. Just saying as a general rule...more of a when in doubt - For Full Recovery DB's I run log backups every 15 minutes so generally...

midnight251 (2/14/2013)

---

Great info thanks. What would a sensible size be, 50 gig? I did notice a 'Shrink File' in the Maintenance Plan, is this what I use for...

UconnDBA (2/12/2013)

---

If creating the reporting databases is the only issue, shouldn't have to reinstall SSRS. Just bring up the Reporting Configuration Manager and on the Database tab click "Change...

There's really nothing involved if you've not customized the config files, just re-install the reporting server - just remember this will delete everything in your RS databases and you will...

In the Start menu, Under Program Files, go to Configuration Tools, then choose "Reporting Services Configuration Manager", you will find out if you are using encryption keys there.

If you don't...

If you don't have any backups to restore you should uninstall and re-install Reporting Services. If you have set any encryption keys or custom changes made to your...

This is not to mention that having an Agent job run a job every 5 seconds would be a foolish thing to do when considering other aspects of the system....

Are you using a custom script or are you using a Maintenance Plan? Could be perhaps some of the backups are going to the default backup folder "<<Installation Path>>"\MSSQL10.MSSQLSERVER\MSSQL\DATA"...

Sorry I have to disagree...I believe it would work perfectly.

If the OP created a job that ran the package I'm describing say every 5 seconds, the package does a check...

At the package level create a package-level variable, set it to data type = String

Create a connection manager for the file (only really needed for the initial set up, as...

Check out this article, I think it will help 🙂

http://www.sqlservercentral.com/Forums/Topic1388718-391-1.aspx#bm1388866

Have you tried initializing it from a full backup? Naturally you would have to change the setting in your publications for "Allow initialization from backup files" to True...and you...

opc.three (2/11/2013)

---

A SQL Agent Alert that leverages WMI could run a Job for you. Lookup SQL Agent Alerts and the WMI Event Class __InstanceCreationEvent.

You could also do this a few...

Regardless, there's little good reason to have that as part of a maintenance plan. If the maint plan rebuilds indexes or updates stats, it'll invalidate the plans that depend on...