Bye.

Thanks for everything,

I don't know if my process is perfect but it works and I just want to share it.

1.- Make a full backup from source DB (remote instance) and...

Thanks for everything, the logshipping process work fine now and all suggestions was very usefull. I just made a new backup from source db (remote instance) and applied a restore...

Ok. I did that, I have created the "service account" as a part of my domain and member of "Administrators" next, I have added the user in the service properties...

¿How can i see the user is running the SQL Server Agent? from Enterprise Manager the properties just have SQL server connection - Windows Authentication.

However in SQL Configuration Manager...

I have a default installation in both SQL instance and I have granted permission in each folder for my domain user and "Domain Administrators".. ¿what user I would to grant...

I use the same Domain/user for all jobs because also is the 'sa' en both SQL instances and additionally for each folder (OS) I have set "Share Permission" and "Security"...

When I see the message history say:

------------------------------------

Message

The job succeeded. The Job was invoked by Schedule 23 (MP - Respaldo Diario.Diario). The last step to run was step 1...

Thanks for reply Cheers,

I got the solution below in a single instruction because we needed to execute the process by demand, but your post using triggers is a valid solution..

Thanks...

Thanks for reply Jeff,

Im working over SQL2005 infrastructure and not DB2, I got the solution with this code that I want to share for other users:

- DB1: is the database...

Thanks Jeff,

Both database are in the same server because they are using the same system but for different little companies in a corporation, so when users add a new product...

I did in different partition and it's work Ok.

Now I'm checking de S.O.

Thank's a lot.

WFunes

I'm making the backup of 6 databases using a backup device or simple file (local partition) and I get the same error just with 2 databases. To discard problems with...

yes, is a local drive.

¿do you think is something related with database?

I'm using the same instruction for make a backup into a backup device for another database and works fine....

My company manage maintenance plans by group of apps with backup devices that include the group app names and the number of the week (It work with a Job that...