July 10, 2007 at 8:54 am
Guys,
I have remote database on west coast which is 60gb, I want to sync copy of the same database (which is in
east coast) at the end of each day. I do not want to use replication because of remoting issues.
On the remote production database we do a transaction log backup every 1hr, is there any way I can copy
the logs and restore it on the copy database. Is there any way to automate the restore process with the
transaction logs backup.
Any suggestions and inputs would help.
Thanks
July 10, 2007 at 9:33 am
Yes you can very well automate this process through log shipping........wat log shipping does is
The basic idea is nothing but backup and restore of the database and transaction logs sequentially from the primary server to secondary or standby server.
Step 1 : Take a Full Backup of the DB to be log shipped in Primary server and restore it in Secondary server with Standyby option.
Step 2 : Backup the T-log in Primary server and restore it sequentially in Secondary server with Standby option.
for further details you can refer my blog,
http://deepakinsql.blogspot.com/2007/06/log-shipping-in-sql-2005.html
http://deepakinsql.blogspot.com/2007/06/prerequisites-for-log-shipping.html
http://deepakinsql.blogspot.com/2007/06/how-to-configure-log-shipping-in-sql.html
[font="Verdana"]- Deepak[/font]
July 11, 2007 at 2:12 am
Yes go for log shipping. But with log shipping you will be only able to read the data and transaction will not be possible if its ok then go ahead else plan a different solution.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 12, 2007 at 5:42 am
dear all,
I have the same sort of scenario which I am looking for, if any of you help me out, i'll great full to you.
I have 2 production server, 1 in my head office and 2 at factory.
I am using Microsoft Dynamics Great Plan ERP solutions with SQL Server 2000 Enterprise Edition.
What we need is, we are using DSL connection which is sometime disconnected due to some reasons.
Our management want to entering data if we lost the connection cause sometime problem cause 3 to 4 days to resolve, in the meanwhile user is stuck up and our head office accounts people not able to enter data or any other payment activities.
Is there any possibility that if we maintain 2 databases having same configuration, our factory users enter data at their factory server and our head office users enter data at HO server. After any specific time, a process execute and sync both server automatically in a way that new entries update from factory to head office and head office to factory.
please note that MSGP data structure maintain auto ID.
If their is any solution, please help me.
Regards
Amin
July 12, 2007 at 5:42 am
dear all,
I have the same sort of scenario which I am looking for, if any of you help me out, i'll great full to you.
I have 2 production server, 1 in my head office and 2 at factory.
I am using Microsoft Dynamics Great Plan ERP solutions with SQL Server 2000 Enterprise Edition.
What we need is, we are using DSL connection which is sometime disconnected due to some reasons.
Our management want to entering data if we lost the connection cause sometime problem cause 3 to 4 days to resolve, in the meanwhile user is stuck up and our head office accounts people not able to enter data or any other payment activities.
Is there any possibility that if we maintain 2 databases having same configuration, our factory users enter data at their factory server and our head office users enter data at HO server. After any specific time, a process execute and sync both server automatically in a way that new entries update from factory to head office and head office to factory.
please note that MSGP data structure maintain auto ID.
If their is any solution, please help me.
Regards
Amin
July 12, 2007 at 6:41 am
hi, you want users to use both ur headoffice and factorys prod servers i.e update simultaneously in any 1 of those depending on the availability....and later jus want to sync both servers........i think it is possible with MERGE replication not sure about it..........but with log shipping its not possible...as it can be used only as a standby server......if your prod server @headoffice is down all your users can conect to the standby server which has the exact replica of your db from production(head office)........so that you can minimize the downtime......
[font="Verdana"]- Deepak[/font]
July 16, 2007 at 2:38 am
MERGE REPLICATION can be used but since you say that auto id is being used in MSGP you have to read replication twice before that can be implemented idenity columns needs to have the property Enabled for replication on also when using merge replication between two databases set the idenity increment seed to ood numbers in one site and even in other so that identity issues are not faced with duplicates.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply