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 go to...

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

Try scheduling it as a job and see it it creates file.

MJ

Simply run the SQL installer again and create a new clustered SQL Instance. Note that the new instance will also need a new, unique IP address and a network name...