Log shipping?

[nowayout]

Hi there,

I am testing logshipping and it is giving me error so please tell me where is am makin mistake.. I am following following steps to do log shipping,

1. Backup,

2. Xcopy to one server to stand by server

3. calling SP to restore database

CREATE procedure restore_database_backup as

restore database test

from disk = 'c:\backup\test.bak'

with

REPLACE,

STANDBY = 'c:\program files\Microsoft SQL Server\MSSQL\data\undo_test_Log.ldf',

move 'test_Data' to 'c:\program files\Microsoft SQL Server\MSSQL\data\test_data.mdf',

move 'test_Log' to 'c:\program files\Microsoft SQL Server\MSSQL\data\op_apps_test_Log.ldf'

WAITFOR DELAY '00:00:05'

EXEC sp_dboption 'test', 'single user', true
GO

it does it then on stand by server the database restored is gone read only mode, and on the production server job which i am running is showing failed? so what is wrong here.

Please guide me,

thanks in advance.