Click here to Skip to main content
11,920,156 members (57,492 online)
Rate this:
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.

Solution 1

The error is pretty self explanatory : you need more space on your c: drive.
Software Engineer 892 22-Mar-13 9:11am
already i have 10gb free space
Mehdi Gholam 22-Mar-13 9:18am
Make more space available then try again.
Software Engineer 892 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.

Mehdi Gholam 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 455
1 phil.o 170
2 CPallini 150
4 F-ES Sitecore 130
0 OriginalGriff 6,778
1 KrunalRohit 4,495
2 Sergey Alexandrovich Kryukov 3,153
3 George Jonsson 2,810
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web02 | 2.8.151120.1 | Last Updated 22 Mar 2013
Copyright © CodeProject, 1999-2015
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