If you created the db with restore database command... you can check the last backup inforamtion info in task pad...or by running the query in msdb...

select top 1 * from msdb..backupset

where...

Most of the time MS will not publish the undocumented details, so you don't find any info from MS.

http://www.norbtechnologies.com/support/articles/article01.asp

I read DBCC PSS is still available (undocumented)

But It is not working for me too

Then qualify the errored table with server name.

remoteservername.distribution.dbo.tablename...

Here is the script...

Declare @BytesUsed Varchar(1000),

 @BytesFree Varchar(1000),

 @TotalBytes BIGINT,

 @IDENTITY INT,

 @Drive Char(1),

 @sql Varchar(1000)

SET NOCOUNT ON

Create table ##DiskSpace ( Drive Char(1), TotalSpace Bigint, FreeSpace Bigint,

PercentageFree as (FreeSpace*100 / TotalSpace )...

Use textdata filter as '%tablename%'

or

You can run the query against syscomments table which will give you table used by procs, triggers and views used..

select distinct object_name(id) from syscomments

where text...

Recycling resolve the issue means, it could be related to cached query plan. Instead of recycle try to recompile the underlying procedure for the job OR alter the procedure to...

Open your format file and change it to 80 and try it.

It is advisable to run the backup to disk and then backup the backup file to the tape.

This way incase you need the backup it is ready on the disk...

I don't think there is way to schedule every three days using nt scheduler...

There is no procedure to get the total space of local drives where as you can get free space available info by running master.dbo.xp-fixeddrives procedure.

select * from orginating_server where job_id = ''

If Orginating_server name is the master server name from where job originated...

You have to write a batch file using NET START and NET STOP commands..

ERwin and ERStudio tools.

I don't know the pricing.