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

Auto Backup and Restore in SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Saturday, November 10, 2012 4:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:17 AM
Points: 206, Visits: 512
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.
Post #1383353
Posted Saturday, November 10, 2012 4:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 23, 2014 5:13 AM
Points: 231, Visits: 759
Why you don t use database mirroring
Post #1383354
Posted Saturday, November 10, 2012 4:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:17 AM
Points: 206, Visits: 512
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.
Post #1383358
Posted Monday, November 12, 2012 11:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 40,609, Visits: 37,070
shohelr2003 (11/10/2012)
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.


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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1383787
Posted Tuesday, November 13, 2012 12:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:17 AM
Points: 206, Visits: 512
@Gila Monster,
Thank you Boss, I will implement Mirroring.
Post #1383954
Posted Wednesday, November 14, 2012 8:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:10 PM
Points: 1,322, Visits: 2,937
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.


Post #1384696
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse