Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database syncronization script for DR Expand / Collapse
Author
Message
Posted Sunday, April 21, 2013 11:06 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:33 AM
Points: 107, Visits: 524
Hi All,

My client is planning to do a daily sycn using backup / restore script. weekly full backup follwed by daily incremental backup to be apply on the secondary server and incase of DR the secondary server will come up using a recover script.

Is there any script available to automate all the process in batch file which will do the backup / restrore activity daily wise.

Waiting for your input.

Thank you all.


Cheers,

Got an idea..share it !!

DBA_Vishal
Post #1444853
Posted Sunday, April 21, 2013 11:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:27 AM
Points: 1,213, Visits: 1,684
Have you thought about using database mirroring or log shipping?
Post #1444859
Posted Monday, April 22, 2013 12:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:33 AM
Points: 107, Visits: 524
Yes we have proposed it but they are not ready for mirroing or log shipping. As the database is very much static and small in size hence daily backup sync is suitable for their environment.

Thats i why Iam looking for a automate script which will do full backup + daily diff.backup and on sec. server it will restore the diff. backup.


Cheers,

Got an idea..share it !!

DBA_Vishal
Post #1444870
Posted Monday, April 22, 2013 1:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 6,351, Visits: 13,681
Whatever you use whether it be

  • Log shipping

  • database mirroring

  • Backup\restore

  • some wierd and wonderful concoction of your own


Remember that server level objects such as logins, agent jobs, etc, etc need to be replicated as a further task to the above.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1444880
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse