SQL Server and OS Error doing DBCC Checkdb and DB Restore
Error message during dbcc checkdb and database restore.
Persisted error message before and after space has increased. We restarted the server, took database offline and brink back online, even moved log to another disk, still same error.
1. First error, we asked for more space and additional 50 GB was given
Server instance: My Instance, Database: Mydb
There is insufficient free space on disk volume 'F:\' to create the database. The database requires 39332085760 additional free bytes, while only 32034734080 bytes are available.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
2. After we added more space of 50 GB the error changes to this:
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 00000000000000000 in file ‘F:\Logs\.Mydb_log.LDF’. Additional message in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
ALTER DATABASE statement failed.
3. We decided to move to another drive, still same error as number 1.
The new drive has 50 GB and reference log file is only 29 GB before shrink and after I shrink, it became 5kb; yet same error during restore.
Server instance: My Instance, Database: Mydb Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.There is insufficient free space on disk volume 'I:\' to create the database. The database requires 61561896960 additional free bytes, while only 53574561792 bytes are available. Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
Persisted error message before and after space has increased. We restarted the server, took database offline and brink back online, even moved log to another disk, still same error.
1. First error, we asked for more space and additional 50 GB was given
Server instance: My Instance, Database: Mydb
There is insufficient free space on disk volume 'F:\' to create the database. The database requires 39332085760 additional free bytes, while only 32034734080 bytes are available.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
2. After we added more space of 50 GB the error changes to this:
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 00000000000000000 in file ‘F:\Logs\.Mydb_log.LDF’. Additional message in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
ALTER DATABASE statement failed.
3. We decided to move to another drive, still same error as number 1.
The new drive has 50 GB and reference log file is only 29 GB before shrink and after I shrink, it became 5kb; yet same error during restore.
Server instance: My Instance, Database: Mydb Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.There is insufficient free space on disk volume 'I:\' to create the database. The database requires 61561896960 additional free bytes, while only 53574561792 bytes are available. Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER