Restore database is failed

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

hello .
i backup my database .
.bak file's size is 12 MB.
but when i want to restore it into aonther server the following error is showed:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore of database 'TaskManager' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'E:\' to create the database. The database requires 36793942016 additional free bytes, while only 19379011584 bytes are available. (Microsoft.SqlServer.SmoExtended)

OK
------------------------------

how can i solve this problem?

Posted 1-Jun-14 2:07am

aliwpf

Add a Solution

Comments

[no name] 1-Jun-14 8:10am

Pick a drive that has sufficient free space or free up space on the E drive.

aliwpf 1-Jun-14 8:12am

i do it. but my problem doesn't solve.

[no name] 1-Jun-14 8:15am

If you actually did it, then your problem would have been solved.

Mike Meinz 1-Jun-14 8:23am

The error message says that it needs almost 37GB to restore your database. Make sure that the disk that you are restoring to has more than 37GB free space. You might want to Defrag that disk before attempting the install.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-06-01T02:29:00

A quick google suggests
http://stackoverflow.com/questions/15348272/insufficient-disk-space-when-restoring-a-small-backup[^] - it's talking about a 23Mb file needing 6Gb, while you are a 12Mb needing 37Gb.

It's worth trying the "sizes" thing to see what you are talking about, and also shrinking the DB before trying the restore: it may be that the current file is enormous and very, very empty!