Modify File Encountered Operating System Error 112error Not Found
Contents |
help? Post your question and get tips & solutions from a community of 418,591 IT Pros & Developers. It's quick & easy. Cant create database error 112 there is not enough space on the disk with > 4 GB log P: n/a Pongthai Hi, I got a backup file operating system error 112 failed to retrieve text for this error reason 15105 from my friend which needs 11 GB to hold the transaction log. I tried to restore this database but an sql server 112 "there is not enough space on the disk" 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
Sql Server Operating System Error 112
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. Jul 20 '05 #1 Post Reply Share this Question 5 Replies P: n/a operating system error 112(error not found) 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 Jul 20 '05 #2 P: n/a Saghir Taj Dear Will, Umm yeh interesting, I am not sure but if t
Products Automation All products Odin Automation Premium All products Operations Automation All products Operations sql backup failed 112 Automation 7.x All products Operations Automation 7.0 Operations Automation
Sql Error 17053
6.x All products Operations Automation 6.0 Operations Automation 5.x All products Operations Automation 5.5
Error: 17053, Severity: 16, State: 1.
Operations Automation 5.4 Operations Automation 5.3 Operations Automation 5.2 Operations Automation 5.1 Operations Automation 5.0 Operations Automation 2.x All products Operations Automation https://bytes.com/topic/sql-server/answers/82083-cant-create-database-4-gb-log 2.9 Operations Automation 2.8 Operations Automation 2.7 Operations Automation 2.6 Business Automation All products Business Automation 7.x All products Business Automation 7.0 Business Automation 5.x All products Business Automation 5.5 Business Automation 5.4 Business Automation 5.1 Business Automation 5.0 Business Automation 6.x All products http://kb.odin.com/en/116575 Business Automation 6.0 Business Automation 4.x All products Business Automation 4.4 Business Automation 4.3 Business Automation 4.2 Business Automation 4.1 Odin Business Automation Standard All products Odin Business Automation Standard 4.x All products Odin Business Automation Standard 4.5 Odin Business Automation Standard 4.3 Odin Business Automation Standard 4.2 Odin Business Automation Standard 4.1 Odin Business Automation Standard 4.0 Odin Business Automation Standard 3.x All products Odin Business Automation Standard 3.4 Odin Business Automation Standard 3.3 Odin Business Automation Standard 3.2 Plesk Automation All products Plesk Automation 11.1 Plesk Automation 11.5 Plesk Automation Billing Odin Automation Essentials All products Odin Automation Essentials 6.5 Odin Automation Essentials 7.0 WPB for Automation Service provider products licensing Other All products H-Sphere All products H-Sphere 3.3 H-Sphere 3.4 All products H-Sphere 3.4.1 H-Sphere 3.5 All products
inHidden fieldsSearch for groups or messages