August 8, 2011 at 10:53 pm
Hi all,
I am restoring Database from one server to another server.following error is getting "not enough storage is available to process this command"
August 9, 2011 at 2:47 am
Check the free drive space. It looks like on the other server there is less free drive space than the size of the database file.
August 9, 2011 at 2:52 am
there is 100gb free space on other server..
August 9, 2011 at 2:57 am
What is the db size?
M&M
August 9, 2011 at 3:04 am
200 gb
August 9, 2011 at 3:13 am
August 9, 2011 at 4:10 am
naresh.talla (8/9/2011)
200 gb
You cannot restore a 200GB database, if free drive space is only 100GB.
August 9, 2011 at 4:21 am
Hard disk size is 300gb free space is 100gb,already the database is there we are just replacing that database.
August 9, 2011 at 4:37 am
How are you restoring the database (GUI, T-SQL, third party), what command is being issued to do the restore, and what is the exact error message that you get?
Thanks
John
August 9, 2011 at 4:38 am
naresh.talla (8/9/2011)
Hard disk size is 300gb free space is 100gb,already the database is there we are just replacing that database.
You might need to drop the existing database and then try restore.
M&M
August 9, 2011 at 5:04 am
hi naresh,
if u r restoring the database through GUI. follow the steps.
1.right click on the databases and select restore database.
2.To database is ur existing database name.
3.in source for restore, select from device radio button
4. find ur .bak file and then select the checkbox below to restore button.
5.In ur left pane click on options and select overwrite existing database check box.
6.Restore database by selecting radio button with recovery .
August 9, 2011 at 5:42 am
We are restoring through Sql Job.when i am restoring from query analyzer database is restored.
August 9, 2011 at 5:42 am
Naresh,
Check if restarting the SQL Server instance before restoring the database helps.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 9, 2011 at 5:50 am
Adiga (8/9/2011)
Naresh,Check if restarting the SQL Server instance before restoring the database helps.
How could that help?
August 9, 2011 at 5:52 am
Adiga,
Can u elaborate briefly with ur reply..
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply