Hi I have planned to go for log shipping to update my database with the production database. I thought of doing like.. 1)Full backup of production DB once and get the backup file to my server so that I Can restore it intially. 2)Trans Backup every 8 hrs and the get the trans backup file to restore on my server. I have to do everything only from my server, not given access to the production except that I may get bckup files when need. All this is just only for 1 DB to update the data for reporting. I have to automate these jobs(pick up files from production and restore on my server) from my server. DO i need to have linked server for this? Pls let me know how far this is possible and any thing else i have to do to accomplish. Thanks! "He laughs best who laughs last"