Those all look like SQL Server 2000 maintenance plan jobs. Are you on SQL Server 2000 or SQL Server 2005?

The outline I provided was based on setting this up...

There is no native way to delete OS files from SQL Server. The basic options are:

xp_cmdshell - allows you to call out to the OS and issue OS commands....

Basic starting point - adjust as needed...

Daily Plan (All User Databases)

Integrity Check

Backup

Remove Old Backup Files

Remove Old Transaction Log Backup Files

Daily Plan (All System Databases)

Integrity Check

Backup

Remove Old Backup Files

Hourly Plan (All...

Other option could be a powershell script - sqlcmd and send the email. It really depends upon what you are doing. For anything that needs to be accessible...

The real question is why do you need to do this in SQL?

Much easier to create a batch file or powershell script to delete files on a regular...

To find out whether or not the data file is growing (autogrowths) you can use the Disk Usage report. Right-click on the database, go to reports and select the...

For a good DR strategy, it has to be either tape or some other media that can be taken offline and shipped to offsite storage. Tape is generally easier...

This is not a problem with the databases - it is a problem with backing up across the network. If there are any issues with the network during the backup,...

For those settings, I use a fixed size and not a percentage. What I try to do is pick a size that will allow for several weeks/months of activity....

First, you should be working in a development/test environment and testing your queries before ever getting them even close to a production system.

Next, you can wrap the process in a...

When you attach the database to SQL Server 2005, the database engine upgrades the files. If it did not perform this upgrade - the engine would not be able...

Okay - that is good. Glad we could help.

Lookup SHRINKFILE in Books Online, but here is how you would do it:

Use ReportServerTempDB;

Go

-- get the logical name of the file

Select *

From sys.sysfiles;

DBCC SHRINKFILE(logicalfilename, size);

Replace logicalfilename with the...

The downside to this is that your procedure could only be run for a single server at a time. Trying to run it from multiple connections will cause problems because...

How about using this:

ALTER DATABASE database_name

SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 };