Thank you for reply

But my script has mix recovery model databases there is 4 or 5 databases have Simple recovery model and rest of them is full recovery model it...

When I put order by cluase, I found something there is one database it stops taking backup and after that any database it doesn't take i.

Thank you all reply

I did two Thing

1) I ran my script manaully it backup and same problem so I took backup inducel database and it work fine by using...

Log file and log file result is below

Executed as user: NT AUTHORITY\NETWORK SERVICE. ...

'test1' on file 1.

[SQLSTATE 01000] (Message 4035) Processed 2 pages for database 'test1', file 'test_log'...

I means there is name upto 33 databases test1 to test33

I have sysadmin write and I all database is online.

These are prductiong databases

DECLARE @dbname VARCHAR(max),

@fullfilename VARCHAR(max),

@getfullfileq VARCHAR(max),

@fullfilebackupq VARCHAR(max),

@deldate datetime,

@getdate-2 VARCHAR(30),

@gettime VARCHAR(8),

@hh VARCHAR (2),

@mm VARCHAR(2),

@ss VARCHAR(2)

/*This command will get all Producation databases with any recovery model*/

DECLARE getdbname CURSOR FOR

SELECT...