InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:37:52 GMT20http://www.sqlservercentral.com/Forums/Topic1383353-391-1.aspxI 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.Wed, 14 Nov 2012 08:57:58 GMTMarkushttp://www.sqlservercentral.com/Forums/Topic1383353-391-1.aspx@Gila Monster,Thank you Boss, I will implement Mirroring.Tue, 13 Nov 2012 00:00:24 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1383353-391-1.aspx[quote][b]shohelr2003 (11/10/2012)[/b][hr][quote][b]ESAT ERKEC (11/10/2012)[/b][hr]Why you don t use database mirroring[/quote]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.[/quote]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.Mon, 12 Nov 2012 11:02:02 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1383353-391-1.aspx[quote][b]ESAT ERKEC (11/10/2012)[/b][hr]Why you don t use database mirroring[/quote]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.Sat, 10 Nov 2012 04:45:57 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1383353-391-1.aspxWhy you don t use database mirroringSat, 10 Nov 2012 04:04:49 GMTESAT ERKEChttp://www.sqlservercentral.com/Forums/Topic1383353-391-1.aspxDear,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.Sat, 10 Nov 2012 04:01:56 GMTshohelr2003