Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Dear Frnds,
 
am working on SqlServer 2005 database. last few days back i have took backup of my SqlServer database. and i Formatted my System.
 
Now i want to restore this database which i have took backup.
 
When i am restoring this database it shows an error.
 
-----------------------------------------------------------------------------------------
Restore failed for Server 'Ranjith-PC'. (Microsoft.SqlServer.Smo)
 
Additional information :
 
System.Data.SqlClient.SqlError: There is insuffieient free space on disk volume 'C:\' to create the database.
The database requires 42485350400 additional free bytes, while only 8938475520 bytes are available.(Microsoft.SqlServer.Smo)
--------------------------------------------------------------------------------------
 
Please help me, how to solve.
 
Thanks in Advance.
Posted 22-Mar-13 4:06am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

The error is pretty self explanatory : you need more space on your c: drive.
  Permalink  
Comments
Software Engineer 892 at 22-Mar-13 9:11am
   
already i have 10gb free space
Mehdi Gholam at 22-Mar-13 9:18am
   
Make more space available then try again.
Software Engineer 892 at 22-Mar-13 9:22am
   
actually this database is of 6,226 kb only.......then what will be the problem. i have still 10gb free space in C drive.
 
Please help me.
 
Thanks...
Mehdi Gholam at 22-Mar-13 9:30am
   
The log files might not be truncated and compacted before backup, so SQL server needs more space to restore.

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

  Print Answers RSS
0 OriginalGriff 7,853
1 Sergey Alexandrovich Kryukov 7,107
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,790


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 22 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100