October 17, 2002 at 9:14 am
Our SQL Servers' data resides on a NAS device. (I know this stinks. Don't yell at me. I am trying to get this changed.)
Anyway, yesterday I was trying to restore a database where both the data and the log reside on this NAS device. When I started the restore, I got an error saying there was insufficient disk space.
Looking at the message, it said the DB was approximately 6 GB but there was only approximately 3.5 GB of space available. I checked the available space on our NAS device and it was over 400 GB free. I then checked the available space on the server that is running the SQL Server engine. The amount of free space was the same amount indicated in the error message.
Can someone tell me if SQL Server actually utilizes the space equal to the DB size on the local server even if the actual DB file will reside on another device.
Also, as a part of changing the way we store data, I am looking to add more DASD to our SQL Servers. Based on what I have read, I need to make sure I have more disk space than is needed for my DBs because the restore function actually creates temporary files in the \BACKUP directory. Can anyone tell me a good rule of thumb for determining the amount of space required?
Thanks in advance for all help.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 17, 2002 at 9:51 am
How much spaces on the NAS do you see from the machine which SQL Server installed by using Windows explorer?
October 17, 2002 at 10:02 am
The NAS device shows 416 GB.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 17, 2002 at 12:19 pm
How do you perform the restoration? Can you post the restoration script and the error messages from SQL Server errorlog?
Try "exec xp_cmdshell 'dir q:\'" (change q to NAS drive letter) to see how much spaces in the NAS drive.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply