April 27, 2007 at 7:47 am
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.
April 27, 2007 at 8:40 am
I dont have any type of dedicated networks as of now, can FTP work for this job. and how about VPN?
April 27, 2007 at 9:20 am
You don't specify if you want to set up built-in SQL Server log shipping (available in Enterprise Edition) or if you're setting up a home grown version.
If you're going the home grown route, check out this script: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=566
Greg
Greg
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply