[dba-SQLServer] SQL Backup and Restore Considerations

David Emerson newsgrps at dalyn.co.nz
Tue Mar 25 22:37:46 CDT 2014


Thanks for the clear description.

David

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia
Sent: Wednesday, 26 March 2014 4:13 p.m.
To: Discussion concerning MS SQL Server
Cc: AccessDSQL
Subject: Re: [dba-SQLServer] SQL Backup and Restore Considerations

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
_______________________________________________
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