You can have SA as the job owner even if the account is disabled. Thats what I do

Stored Procedure which creates a scheduled backup job to run the SP that backs the database up..

To run this

Exec dbo.createbackupProc [Database name], [Number of stripes]

/****** Object: StoredProcedure [dbo].[CreateBackupProc] ...

Declare @subdirinput nvarchar(200)

DECLARE @Databasename NVARCHAR(50);

DECLARE @Subdir NVARCHAR(150);

SELECT @Databasename = (SELECT DB_NAME());

select @subdirinput = (select variable from dba.dbo.variables where process = 'backuppath') -- Change this to Backup Path

declare @splits1 varchar(5)

select @splits1...

Splits is for the amount of backup files you want to crearte by the way, having multiple files per backup speeds up the backup process.. 5 to 8 seems to...

Thanks keith

Ignore this post... sorted it . Had a blonde moment

users get

"Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."

Permissions have been granted to both the site settings level and report folder...

Yep that is all set.

It works fine for me, locally and remotely. But i am system admin on the box. It works fine for other users if I add...

I am still struggling with this, it works fine if the user is local admin on the box but will not work at all if they are not.

Virtual log files are created each time your log file needs to grow, so there is a direct link between VLFs and the growth settings.

You want to keep the number...

thanks for that! Worked a treat

use [database]

Grant PERMISSION on [tablename] to

Do you have a report which is trying to use the credentials with the wrong password?

Kurt, Making those adjustments still came back with the same error - very strange I can't see where it is getting it from.

Ed, "using select QUOTENAME(name) from sys.indexes" worked...

Appreciate your feedback guys, I will make the changes this afternoon.

Thanks for taking the time to test it Kurt, appreciate it and I prefer your way around nulls too.

I appreciate...