Thursday, February 16, 2012

Attaching DB Question

Hello,
When attaching a db with no logfile is there a way to make to logfile larger
than 1MB?
Any help greatly appreciated!
Thanks in advance.Hello,
By default SQL Server will create a LDF file with 504 KB. After that you
could manually expand the Log file to required size.
Thanks
Hari
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:9F17359E-7908-4071-8F7B-846FE07AA562@.microsoft.com...
> Hello,
> When attaching a db with no logfile is there a way to make to logfile
> larger
> than 1MB?
> Any help greatly appreciated!
> Thanks in advance.
>
>

No comments:

Post a Comment