[dba-SQLServer] From a reader

Asger Blond ab-mi at post3.tele.dk
Thu Apr 2 15:08:06 CDT 2009


Just tell him (as suggested by Francisco) to restore the most recent full
backup with norecovery and then all subsequent log backups with norecovery
except for the last log backup which should be restored with recovery.
Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Susan
Harkins
Sendt: 2. april 2009 19:58
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] From a reader

Thanks Francisco and Nancy -- I don't support a SQL Server so these 
administrative issues are over my head. :)

Susan H.


> All Sql Server Backups are Serialized, that means you need to restore in
> that specific order with a Full Backup always being the 1st backup you can
> restore.  Thus if you reader restore the Sunday Full backup, and has a 2nd
> Full Backups on Monday, he needs to restore the 2nd Full backup with

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list