[dba-SQLServer] Attach a database without its log file

jwcolby jwcolby at colbyconsulting.com
Mon May 23 13:55:19 CDT 2011


yep, it creates a new one.

John W. Colby
www.ColbyConsulting.com

On 5/23/2011 2:25 PM, Arthur Fuller wrote:
> Is it possible to attach a database without its log file? It occurred to me
> that I could create an empty database, then copy its log file to a new name,
> then attach the database, but I haven't tried it yet.
>
> TIA,
> Arthur
> _______________________________________________
> 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