Done.

Thanks everybody for sharing knowledge.

Jeff,

I have applied the valid product key but according to your procedure (to confirm) the second row just say "Microsoft SQL Server Standard Edition (64-bit)"

I just want to be...

After apply the new product key (valid) ¿how can I be sure is not a free evaluation?

where i can check that

I have already solved.

Thanks for helping me.

Keith,

Thanks for sharing the procedure.

¿Is the same when you use the Installation CD (Maintenance - Edition - Upgrade)?

Thanks for sharing your experiences,

I will try to apply it.

Thanks, I will try to do it right now.

thanks,

I was trying to chanche the collation server without re-install the SQL_Server because when someone create a new object its have a wrong collation... according to our application.

So I want...

I have noticed the problem occurs when I define the job schedule for restoring database since 22:00 to 06:00 and the backup_job and Copy_job in 15 mins from 12:00 am...

I just have finished the new logshipping process with the "StandBy Mode" choice at the end but when I force the "Restore_Job" just for apply the trn backup the database...

You're right the last step when you setup the Restore_Job say "StandBy mode" could be an little mistake... I've set again the database and I hope it work.

My logship procedure...

Hi, the first time I did setup the logshipping process, the destination database changed to StandBy/Read-Only after the first restore was applided and it was nice because users can make...

Thanks for everything.

Regards.

Ok, imagine you have a disaster in (source database) what procedure would you apply in destination database for leaving ready to use it.

thats my first time and I was thinking...

Thanks for sharing your production LogShipped schedule, I just have a question with your Log Shipping schema. the Job backup (every 15 mins) job copy (every 15 mins)...