Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sudheer.v538@gmail.com
Starting Member
10 Posts |
 Posted - 2008-05-19 : 08:52:45
|
| Hi, I am trying to restore a production copy. I have only the .bak file with me. While restoring, i m facing the following error. can u please help me... thanks in advance. "MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."I have placed the data files(52GB) in D: drive(140GB free space) and transaction log file(100GB) in F: drive(465GB free space). Still i am facing this error...-- Sudheer |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-19 : 23:25:04
|
| Find out space needed with 'restore filelistonly'. |
 |
|
|
sudheer.v538@gmail.com
Starting Member
10 Posts |
Posted - 2008-05-20 : 06:59:42
|
quote:
Originally posted by sudheer.v538@gmail.com
Hi, I am trying to restore a production copy. I have only the .bak file with me. While restoring, i m facing the following error. can u please help me... thanks in advance. "MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."I have placed the data files(52GB) in D: drive(140GB free space) and transaction log file(100GB) in F: drive(465GB free space). Still i am facing this error...-- Sudheer
Required size for the transactional log file is 140GB.Sudheer |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 22:29:57
|
| What kind of file system do those disks use? FAT or FAT32 have 4gb file size limit. |
|
|
|
sudheer.v538@gmail.com
Starting Member
10 Posts |
Posted - 2008-05-21 : 09:54:04
|
| All the disks are of NTFS file system.Sudheer |
|
|
|
sudheer.v538@gmail.com
Starting Member
10 Posts |
Posted - 2008-05-21 : 09:56:56
|
| All the disks are of NTFS file system.Sudheer |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-21 : 22:33:43
|
| What does 'restore filelistonly' tell you? |
|
|
|
sudheer.v538@gmail.com
Starting Member
10 Posts |
Posted - 2008-05-22 : 09:02:32
|
| Thank you for ur response, i got the solution for this problem. Actually we have the removable HDD(F: drive). It was not formatted earlier to the restore. After formatting the HDD, i can be able to restore successfully.Thanks again...Sudheer |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-25 : 12:00:21
|
| Actually if you add new SAN drive on the server you have to format it first and then only you can keep your files.Also, I would recommend that give the permission on file system. So no one can access the folder and can not play with data/log/backup files.ManojMCP, MCTS |
|
|
|
|
|
|
Restore failed in sql server 2005.