April 30, 2003 at 8:02 am
Hi!
While backing a SQL database onto another system after mapping the drive I get this error saying "Operating system error 112(There is not enough space on the disk.)..". There's a lot of space on the Destination server.
But when I back it up onto the same machine the backup's successfull.
I'm not even able to copy and paste the backed up file onto another machine. can someone help me out on this
The size of the DB is 5GB. Is it the problem with the size??
I'm logged in with Sa user on the server and also logged on in administrative mode on both the machines (source and destination servers)
Bharat Raju N.V.S
Bharat Raju N.V.S
April 30, 2003 at 8:14 am
How much free space on the other machine? 5g file should not be a problem, could be that the free space calculation is blowing up if there is 'too much' free space.
Andy
April 30, 2003 at 11:35 am
If you open a command prompt from the source to the destination and do a dir, do you have enought space?
Steve Jones
April 30, 2003 at 12:14 pm
Where are you trying to save it on the destination server? Is it a partitioned drive? How much space is in that partition?
For example: The destination server could have a drive partitioned into C and D. All together they could have 10GB free space, but the C drive could only have 2 GB left and the D drive would have 8 GB left. If you were saving to the C drive, there wouldn't be enough room.
-SQLBill
May 2, 2003 at 6:52 am
quote:
Hi!While backing a SQL database onto another system after mapping the drive I get this error saying "Operating system error 112(There is not enough space on the disk.)..". There's a lot of space on the Destination server.
But when I back it up onto the same machine the backup's successfull.
I'm not even able to copy and paste the backed up file onto another machine. can someone help me out on this
The size of the DB is 5GB. Is it the problem with the size??
I'm logged in with Sa user on the server and also logged on in administrative mode on both the machines (source and destination servers)
Bharat Raju N.V.S
No It's not the problem with the space the HDD is a brand new one with only a single partition.
I goofed up I was trying to backup the drive to a FAT32 partition. I just realised that we can't move a file which's more than 4GB.
I changed the partition to NTFS...Now I'm able to copy paste the backed up file from source to destination... I've come across a new problem now. The backup's terminating and giving the following error..
Cannot open backup device 'Drive:\path\x.bak'. Device error or device off-line. See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally.
can you please help me out on this
and Thanks a lot for your Help.
Bharat Raju N.V.S
Bharat Raju N.V.S
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply