November 10, 2012 at 4:01 am
Dear,
I have two servers such as A and B.
A is my main server and B is my backup server.
My purpose is to avail data in B from A so that I can use B if A faces any disaster.
I planned to take a full backup on A and restore it to B. After that I will take differential backup from A and restore it to B automatically. And the backup file stored in B will be deleted after a certain period of time.
Is there any inconsistency with my plan? If it is fine, pls let me know the details to implement this on my database.
Thank You.
November 10, 2012 at 4:04 am
Why you don t use database mirroring
November 10, 2012 at 4:45 am
ESAT ERKEC (11/10/2012)
Why you don t use database mirroring
In database mirroring, if the primary database is corrupted for any reason other than hardware failure, then the mirror database will be corrupted in the same way.
So it's risky to implement.
November 12, 2012 at 11:02 am
shohelr2003 (11/10/2012)
ESAT ERKEC (11/10/2012)
Why you don t use database mirroringIn database mirroring, if the primary database is corrupted for any reason other than hardware failure, then the mirror database will be corrupted in the same way.
No it won't.
Unless by 'corruption' you mean user deleting the incorrect data, in which case your backup/restore will have the same problem.
In fact, backup/restore will copy across page corruption while mirroring won't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2012 at 12:00 am
@Gila Monster,
Thank you Boss, I will implement Mirroring.
November 14, 2012 at 8:57 am
I have several databases that I schedule backup/restores to and have scripts inside the restore job to add/reset users and the like as well..... One example is a weekly prod to test db refresh.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply