Cant create database with > 4 GB log

[Pongthai]

Hi,

I got a backup file from my friend which needs 11 GB to hold the
transaction log. I tried to restore this database but an error
message:

"MODIFY FILE encountered operating system error 112(error not found)
while attempting to expand the physical file."

appeared. The free space is more than enough. I then tried another way
to create a database with a 11 gb log file but it fails with the same
error message whenever I tried to create any database with a file
larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
this the cause of this limitation?

p.s. I'm very new to the SQLServer.


Pls Help,
Will.

[Simon Hayes]

Re: Cant create database with > 4 GB log

pongthai@msn.co m (Pongthai) wrote in message news:<4bf99b6f. 0405042008.9cc4 e14@posting.goo gle.com>...[color=blue]
> Hi,
>
> I got a backup file from my friend which needs 11 GB to hold the
> transaction log. I tried to restore this database but an error
> message:
>
> "MODIFY FILE encountered operating system error 112(error not found)
> while attempting to expand the physical file."
>
> appeared. The free space is more than enough. I then tried another way
> to create a database with a 11 gb log file but it fails with the same
> error message whenever I tried to create any database with a file
> larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> this the cause of this limitation?
>
> p.s. I'm very new to the SQLServer.
>
>
> Pls Help,
> Will.[/color]

I believe that 4GB is the maximum file size on a FAT32 filesystem, so
I would guess your hard drive is formatted with FAT32, not NTFS. You
should be able to convert it, as described here (make sure you back up
your data first):

http://support.microsoft.com/default.aspx?scid=kb;en-us;307881

NTFS is the recommended filesystem for both Windows XP and SQL Server.

Simon

[Saghir Taj]

Re: Cant create database with &gt; 4 GB log

Dear Will,

Umm yeh interesting, I am not sure but if the problem is "4GB", it may
be due to 4GB Memory constraint... However, the error number you
report belongs to operating system not SQL Server and it means disk is
full, no space for any more 0101010 on the disk!
:-)

Exact description of Error
"112 there is not enough space on the disk. ERROR_DISK_FULL "

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/system_error_codes__0-499_.asp

Please describe things a lil more

Thanks!
Me,
Saghir Taj
MCDBA




pongthai@msn.co m (Pongthai) wrote in message news:<4bf99b6f. 0405042008.9cc4 e14@posting.goo gle.com>...[color=blue]
> Hi,
>
> I got a backup file from my friend which needs 11 GB to hold the
> transaction log. I tried to restore this database but an error
> message:
>
> "MODIFY FILE encountered operating system error 112(error not found)
> while attempting to expand the physical file."
>
> appeared. The free space is more than enough. I then tried another way
> to create a database with a 11 gb log file but it fails with the same
> error message whenever I tried to create any database with a file
> larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> this the cause of this limitation?
>
> p.s. I'm very new to the SQLServer.
>
>
> Pls Help,
> Will.[/color]

[Pongthai]

Re: Cant create database with &gt; 4 GB log

Thanks for both answers. I'll have one of my hdd partition changed to
NTFS and try again.

Thanks,
Will.

[Saghir Taj]

Re: Cant create database with &gt; 4 GB log

Simon may be right this may be one of cause!.. i would like to know
the exact cause of problem.. if you get some fix or exact descripton
of problem please let me know!

Me,
Saghir Taj
MCDBA


sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0405050216.555c f13c@posting.go ogle.com>...[color=blue]
> pongthai@msn.co m (Pongthai) wrote in message news:<4bf99b6f. 0405042008.9cc4 e14@posting.goo gle.com>...[color=green]
> > Hi,
> >
> > I got a backup file from my friend which needs 11 GB to hold the
> > transaction log. I tried to restore this database but an error
> > message:
> >
> > "MODIFY FILE encountered operating system error 112(error not found)
> > while attempting to expand the physical file."
> >
> > appeared. The free space is more than enough. I then tried another way
> > to create a database with a 11 gb log file but it fails with the same
> > error message whenever I tried to create any database with a file
> > larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> > this the cause of this limitation?
> >
> > p.s. I'm very new to the SQLServer.
> >
> >
> > Pls Help,
> > Will.[/color]
>
> I believe that 4GB is the maximum file size on a FAT32 filesystem, so
> I would guess your hard drive is formatted with FAT32, not NTFS. You
> should be able to convert it, as described here (make sure you back up
> your data first):
>
> http://support.microsoft.com/default...b;en-us;307881
>
> NTFS is the recommended filesystem for both Windows XP and SQL Server.
>
> Simon[/color]

[sara123]

hi

has the problem solved

i am also facing the same problem

sara