Run restore headeronly from disk='backupfilenamewithpath' and chk column named 'backup type' in output.

Backup type:

1 = Database

2 = Transaction Log

4 = File

5 = Differential

Database

6 = Differential File

MJ

Try running the job after changing the owner to 'sa' if its not sa. Also, try running the job step script manually under SSMS after logging in with user account...

Try:

On Pri. server

select * from msdb.dbo.log_shipping_primary_databases

On Sec. server

select * from msdb.dbo.log_shipping_secondary

BRU is TRUe.

MJ

Casper,

Use the column named 'AVERAGE_BYTES_PER_ROW' generated by attached script and multiply it with number of rows that qualifies for deletion for that particular year. It will give you an estimate.

Note:-...

Try specifying a job log file in that stored procedure execution step which is failing and post the error message from log file here.

MJ

Example:

CREATE TABLE [dbo].[Statsdate] (

[Statsdate] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

declare @pos int

insert statsdate

EXEC master..xp_cmdshell 'net STATISTICS server | find "Statistics since"'

delete from statsdate where statsdate is null

select @pos=...

Better take it in a sql table and format it there.

MJ

Run 'sp_helpuser' under SSMS and see if that windows group actually got that role assignment or not.

MJ

What message do u get in SSMS once you run tht t-sql statement?

Manu

Your script returns incorrect time when job executes before noon time.

Use this:

SELECT jobs.name as 'JOB_NAME',his.message as 'MESSAGE',

ISNULL(SUBSTRING(CONVERT(varchar(8),his.run_date),7,2) + '/'

...

http://msdn.microsoft.com/en-us/library/aa197143(SQL.80).aspx

We had the same error message with our Server. One thing that I remember from it that it will work if you are using a SQL login but if you...

Try:

http://www.ureader.com/msg/1161666.aspx

To resolve this problem:

1. I changed Log On information of MSSQLServer from Windows Services.

2. I also changed Log On information of SQLServerAgent from Windows

Services.

To do 1 & 2...

http://www.sqlservercentral.com/Forums/Topic418752-146-1.aspx