I'm quite new in database field as a Database Aministrator. Appreicate if
anyone able to me on this.

We receive several trouble ticket regarding Log Shipping job failure issues.
When i check the database status in MS SQL, the database status show as
"Standby / Read-Only".

The job error message as below:
Executed as user: EUROPE\service_sql_admin. sqlmaint.exe failed. [SQLSTATE
42000] (Error 22029). NOTE: The step was retried the requested number of
times (3) without succeeding. The step failed.

My question, will log shipping job execute when the particular database set
to read-only?

Jimmy
I can only guess that you have "attempt to repair minor problems" for which
sqlmaint.exe needs to set up the db in
single user mode. It will not force out connected users so you get an error
instead.

Also read this article

http://www.sql-server-performance.co...ing_70_p1.aspx


"Jimmy Liew" <Jimmy Liew@discussions.microsoft.com> wrote in message
news:00291A79-007E-439E-A3F2-DCEA83A770C3@microsoft.com...
> I'm quite new in database field as a Database Aministrator. Appreicate if
> anyone able to me on this.
>
> We receive several trouble ticket regarding Log Shipping job failure
> issues.
> When i check the database status in MS SQL, the database status show as
> "Standby / Read-Only".
>
> The job error message as below:
> Executed as user: EUROPE\service_sql_admin. sqlmaint.exe failed. [SQLSTATE
> 42000] (Error 22029). NOTE: The step was retried the requested number of
> times (3) without succeeding. The step failed.
>
> My question, will log shipping job execute when the particular database
> set
> to read-only?

> When i check the database status in MS SQL, the database status show as
> "Standby / Read-Only".

Most probably you configured log shipping to restore the log backups using the STANDBY option. This
mean that you can read in the database and still restore further backups. The tools like EM and SSMS
presents this as standby/read-only.

So, this is most probably normal and probably not the reason for the failure. There should be other
logs etc you can check for detailed error message why the restore failed. One possibility is that
someone was connected to the database when the restore was attempted.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Jimmy Liew" <Jimmy Liew@discussions.microsoft.com> wrote in message
news:00291A79-007E-439E-A3F2-DCEA83A770C3@microsoft.com...
> I'm quite new in database field as a Database Aministrator. Appreicate if
> anyone able to me on this.
>
> We receive several trouble ticket regarding Log Shipping job failure issues.
> When i check the database status in MS SQL, the database status show as
> "Standby / Read-Only".
>
> The job error message as below:
> Executed as user: EUROPE\service_sql_admin. sqlmaint.exe failed. [SQLSTATE
> 42000] (Error 22029). NOTE: The step was retried the requested number of
> times (3) without succeeding. The step failed.
>
> My question, will log shipping job execute when the particular database set
> to read-only?