Click here to Skip to main content
11,637,415 members (58,823 online)
Rate this: bad
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 3: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 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.

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 295
1 stibee 288
2 270
3 Sergey Alexandrovich Kryukov 224
4 himanshu agarwal 184
0 OriginalGriff 9,031
1 Sergey Alexandrovich Kryukov 8,643
2 Mika Wendelius 6,959
3 F-ES Sitecore 2,388
4 Suvendu Shekhar Giri 2,320

Advertise | Privacy | Mobile
Web01 | 2.8.150728.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