[dba-SQLServer] SQL Backup and Restore Considerations

Francisco Tapia fhtapia at gmail.com
Tue Mar 25 22:12:51 CDT 2014


Shameless plug

http://sqlthis.blogspot.com/2008/06/change-your-recovery-model.html


—
Sent from Mailbox for iPhone

On Tue, Mar 25, 2014 at 7:40 PM, David Emerson <newsgrps at dalyn.co.nz>
wrote:

> Listers,
>  
> I have a client that wants to use transaction logs to back up data so that
> they can recover everything (not just the last 5 minutes) that was entered
> prior to a system meltdown.
>  
> Are the different methods of backup and restore in SQL 2008 able to be
> changed after the database has been initially created or is the method
> locked down as part of the database creation process?
>  
> Regards
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>  
>  
>  
> _______________________________________________
> 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