Good Evening Gail ,

Thanks a lot for the update.

googling i found below command .i hope this is the right

RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'

WITH NORECOVERY

GO

RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN'

WITH RECOVERY,

STOPAT = 'Mar 23, 2009 05:31:00 PM'

GO.

One more thing Gail ,if my log destination gets full,what is the best option to reduce it.

Regards