This is by ssms using generate script task.

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Here is script to copy the schema

http://www.sqlservercentral.com/scripts/T-SQL/75703/

You can use both Rtrim and Ltrim at a time to get rid from both prefix and suffix.

Select Ltrim(rtrim(column))

Is there any specific error you are seeing in logshipping monitor or in error log?

For me also it's working. mine also same SQl Server 2008 SP1

Check this.

http://www.sqlservercentral.com/Forums/Topic1213478-392-1.aspx

http://support.microsoft.com/kb/264474

What is recovery model of your database? if it is full then you have to change it to bulk logged recovery.

For resolving the logshipping out of sync issue. generally you have restore the full backup of your primary database to secondary server.

Good article.

Please post the Query execution plan. it will help to analyse more.

you can try with powershell to extract data from SQL server.

Here is some example.

http://www.sqlservercentral.com/articles/powershell/65196/

Welcome:-)

what is the value for counter Physical Disk Object: Avg. Disk Queue Length?

Please provide the drive details like RAID type that you are using?

Here is your query.

http://sqlblog.com/blogs/john_paul_cook/archive/2009/08/24/using-the-processes-query-outside-of-activity-monitor.aspx

use below query

select database_name, type, first_lsn, last_lsn ,checkpoint_lsn ,database_backup_lsn

from msdb..backupset where database_name = 'DBNAme'