Create MMSQL backup script and script to restore to different server
$30-250 CAD
Paid on delivery
I have an SQL Server maintenance task running that takes full daily and differential hourly backups from my SQL Server 2008. I have backup software installed that can restore to the same machine but not to another server.
We have a backup DR server (SQL Server 2008R2) and I want to be able to restore the backups to the backup server in case of a total failure but the DR server will have a different hostname so I am looking for someone who can either just create a SQL script to restore to Point of Time of last SQL backup to alternate server and if necessary, create different backup script on source server if necessary. The backups are stored on an external drive so they would be accessible in the event of a total machine failure.
There are about 16 databases on the server which are currently all being backed up as part of a backup set. The databases are set to Full recovery mode.
Project ID: #12008707
About the project
8 freelancers are bidding on average $128 for this job
Over 5 years experience in Customer Support, Technical Support, Incident Management, Process Improvement, and Projects Management using my database administration knowledge in information technology field with many com More
I Working as DBA Analist in a BIG Company. I know SQL SERVER and Oracle. I know how help you. I use SQL SERVER 2012 and 2014 and I have script.
I have an automated script for do that just need to be sure that are same paths on backup and dr server
