Auto Backup and Restore in SQL Server 2008 R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Auto Backup and Restore in SQL Server 2008 R2...

Auto Backup and Restore in SQL Server 2008 R2

Rate Topic

Display Mode

Topic Options

Author

Message

shohelr2003

Posted Saturday, November 10, 2012 4:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

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

ESAT ERKEC

Posted Saturday, November 10, 2012 4:04 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 5:27 AM
Points: 222, Visits: 708

Why you don t use database mirroring

Post #1383354

shohelr2003

Posted Saturday, November 10, 2012 4:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

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

GilaMonster

Posted Monday, November 12, 2012 11:02 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:00 PM
Points: 37,744, Visits: 30,024

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

shohelr2003

Posted Tuesday, November 13, 2012 12:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

@Gila Monster,
Thank you Boss, I will implement Mirroring.

Post #1383954

Markus

Posted Wednesday, November 14, 2012 8:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 1,048, Visits: 2,217

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 »

Permissions