January 10, 2012 at 7:29 pm
Hi ,
Here is the weird scenario
One of our client prod database functioning in client place (as per agreement). We don't have access to our own application database.
Now for bussines analysis, we are going to ask client to have a copy of database and sync periodically.
what is the best way to do this? can I set up logshipping between 2 different datacenter servers? if so
what kind of things we need to set up or ask client to provide. Thank you.
January 10, 2012 at 9:05 pm
How often does this database need to be synced? Could the client simply send you an encrypted and password protected zip file of a current full database backup?
January 10, 2012 at 11:09 pm
what is the best way to do this? can I set up logshipping between 2 different datacenter servers? if so
what kind of things we need to set up or ask client to provide. Thank you.
You can configure the log-backup. Pre-requisite for log backup:-
1) Shared folder to place the backup file on primary server and adequate permission to sql agent acnt.
2) Shared folder to copy the backup file on secondary server and adequate permission to sql agent acnt.
3) Well analysed backup strategy like, how frequently we need secondary server to be refreshed. Based on that, job for full backup daily and log backup at regular interval on primary server.
4) Restore the full backup on secondary server with standby option so that you can read it. Once its done, schedule the job for log restore on regular interval.
5) Maintenance job on both server , primary and secondary, to delete the "n" min/hr old backup file from both shared server.
note :-
I mentioned "sql agent acnt" as the candidate for permission as I am assuming you using the jobs to do this activity on scheduled basis.
I might be overlooking of something so do proper testing of this plan before implementing it on live system.
----------
Ashish
January 11, 2012 at 1:58 am
laddu4700 (1/10/2012)
Hi ,Here is the weird scenario
One of our client prod database functioning in client place (as per agreement). We don't have access to our own application database.
Now for bussines analysis, we are going to ask client to have a copy of database and sync periodically.
what is the best way to do this? can I set up logshipping between 2 different datacenter servers? if so
what kind of things we need to set up or ask client to provide. Thank you.
I have done exactly this on a previous occasion from UK to USA. Log shipping was easier to set up and maintain and the database was left read only for users
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 3:33 am
Other possible options:
1) Snapshot replication
2) Transactional replication
In both cases you could set up row and column filters and replicate just what you really need.
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply