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]

po******@msn.com (Pongthai) wrote in message news:<4b*************************@posting.google.c om>...

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.

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

[Saghir Taj]

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/de...es__0-499_.asp

Please describe things a lil more

Thanks!
Me,
Saghir Taj
MCDBA


po******@msn.com (Pongthai) wrote in message news:<4b*************************@posting.google.c om>...

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.

[Pongthai]

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

Thanks,
Will.

[Saghir Taj]

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
sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...

po******@msn.com (Pongthai) wrote in message news:<4b*************************@posting.google.c om>...

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.

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

[sara123]

hi

has the problem solved

i am also facing the same problem

sara