May 30, 2011 at 11:12 am
Hi,
We have a develpment server just same as the production server.
We take backups of all the dbs on the production server daily night.
There is no db on the development server (we just build it up).
So i was trying to set up the same dbs on dev server and so i started the restore database from the SSMS.
I tried 2 things...
Firstly, Restore db command and then selecting .bak file from different server
Secondly, copying the .bak file locally
Both these steps i receive same error :-
" Not enough server storage is available to process this command"
Interestingly, i have around 800 gb free space on my drives, where i am copying..
Wat should I do?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 11:14 am
and the bak file is just 150 gb
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 11:15 am
How big is the database once restored?
You could possibly have a 200 GB backup file but with a 1 TB db once fully restored, that could explain this.
May 30, 2011 at 11:20 am
Its nt tht big..
mdf file 310 gb
log file 1 gb
.bak file 150 gb
Space is not an issue because i tried on diff drive also ( drive had 1.2 TB free)
There also i received same error.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 11:34 am
any 3rd party application that may be compressive the drive and preventing the drive from getting filled up beyond x%?
Maybe norton AV or something similar getting in the way?
May 30, 2011 at 11:36 am
Are you connected on the correct server for the restore?
Does the server have enough permissions to write on the disk(s)?
May 30, 2011 at 11:45 am
not much on the server as its newly build ...it has
Microsoft dynamics Great Plains
SQL server 2005
Acronis true image server and
symantec endpoint protection
Yes, im connected to right server for restoration.
How to know if server has permissions to write on disk? ( isn't that self built )
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 11:48 am
Take a backup of a small and try restoring it to the same driver / folder that is giving you the error.
That may also give you an opportunity to figure out at what point the server throws you the error. At that point I'd start looking in all the logs of the machine to maybe get a more usefull error message.
May 30, 2011 at 12:44 pm
at a wild guess i would say the original disk locations do not exist on the new server.
Does the new server have the same drive letters and paths?
If not you would need to provide the MOVE clause during the restore to move the database files to the correct drives\paths
try the following and validate the physical filename paths against the new server
RESTORE FILELISTONLY FROM DISK = 'drive:\path\backfile.bak'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 1:13 pm
Ninja's_RGR'us (5/30/2011)
Take a backup of a small and try restoring it to the same driver / folder that is giving you the error.That may also give you an opportunity to figure out at what point the server throws you the error. At that point I'd start looking in all the logs of the machine to maybe get a more usefull error message.
Other small dbs backups from production , i already restored them on the same drive.
I didnt get any error in those.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 1:15 pm
Perry Whittle (5/30/2011)
at a wild guess i would say the original disk locations do not exist on the new server.Does the new server have the same drive letters and paths?
If not you would need to provide the MOVE clause during the restore to move the database files to the correct drives\paths
try the following and validate the physical filename paths against the new server
RESTORE FILELISTONLY FROM DISK = 'drive:\path\backfile.bak'
When i am doing restoring from the SSMS, i am selecting the new mdf and ldf locations...
I am now trying to restore the database from the query analyzer ( by query)..
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 1:43 pm
does your service account have the needed windows auth to process the restore command using the file location of the back file ?
Please post the (generated) restore statement and the exact error message.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 30, 2011 at 3:05 pm
When iam restoring via this query :-
RESTORE DATABASE RTW
FROM DISK = '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'
WITH MOVE 'GPSRTWDat.mdf' TO 'E:\MSSQL\Data\RTW.mdf',
MOVE 'GPSRTWLog.ldf' TO 'E:\MSSQL\Data\RTW.ldf',
STATS=5
It does 30% and then throws this ERROR:--
30 percent processed.
Msg 3203, Level 16, State 2, Line 1
Read on "\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak" failed: 1130(Not enough server storage is available to process this command.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 30, 2011 at 4:13 pm
Here's another fun test.
Restore 1 small db. Then grow the files by 1 Gb in a loop untill it fails (either drive full or the previous error).
I googled the error and all the links point to windows and network settings.
So assuming you're able to fill up the drive then the problem is outside the drive and sql server.
May 30, 2011 at 11:46 pm
If you have enough space on the drive, copy the backup file locally and then perform the restore (using the local file).
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 15 (of 34 total)
You must be logged in to reply to this topic. Login to reply