InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:05:01 GMT20http://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxIf you log load isn't that much, you may want to consider making a full backup and use log backups. Then you can restore the full backup (norecovery) (first time) and a first log backup with STANDBY to a file.This db will then be read only ! and you can issue subsequent log- restores to new standby file.Fri, 12 Sep 2008 07:34:32 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxIt does the restore (4+hours). That's the only way to do a differential restore is to base it on a Full that was run without Recovery.If you need to have a copy of the database daily have you looked at REPLICATION? If it's a daily thing you could look at using SNAPSHOT replication on a daily basis.Fri, 12 Sep 2008 07:09:57 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxRegarding the Monday through Saturday full restore with NORECOVERY; will it actually do a restore (hence taking 4+ hours) or does it merely set it up for the partial and hence complete quickly?Fri, 12 Sep 2008 06:58:13 GMTrtimblinhttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxIn your case your script should do this:[ul]1. Sunday after the full backup a Full Restore with Recovery2. Monday - Saturday 1. Restore the Sunday Full Backup with Norecovery 2. Restore the daily differential Backup with Recovery[/ul]Thu, 11 Sep 2008 10:13:54 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxIn the scenario, we would do a full on Sunday night and a differential each weekday and Saturday. However, it sounds like after you do the full, the database would be left in a READONLY state, in order to allow differential restores to be done each night; which foils what we wanted to do, if I understand it correctly. Is that correct?Thu, 11 Sep 2008 09:24:00 GMTrtimblinhttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxJack is correct. The diff stores changes SINCE the full. So it doesn't have a baseline on which to work. A diff is used to reduce the number of log restores you need to do, not prevent you from restoring a full backup.Thu, 11 Sep 2008 09:08:40 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxYou cannot just restore from differential backup. You need to do a full restore with norecovery first then restore the differential with recovery.Thu, 11 Sep 2008 08:20:30 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic567705-54-1.aspxWe want to do a differential restore each evening via script from one database to another. The script we are using is below. Also, the error we get is below. We cannot afford to due a full restore each evening also which would negate the reasoning behind a partial/differential backup/restore.ERROR: The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequenceSCRIPT:ALTER DATABASE xxx SET SINGLE_USER WITH ROLLBACK IMMEDIATEGORESTORE DATABASE xxxFROM DISK='D:\xxx\xxx.bak'WITH MOVE 'DATA01' TO 'F:\xxx\data\xxx_Data.mdf', MOVE 'LOG01' TO 'F:\xxx\log\xxx_Log.ldf', RECOVERYGOALTER DATABASE xxx SET MULTI_USER WITH NO_WAITGOThu, 11 Sep 2008 07:29:14 GMTrtimblin