I'm trying to backup a database in SQL Management Studio onto a hard drive with 931GB free space. I keep getting an error message saying there is not enough free space, but the database is only 52GB in size so there should be plenty of space.

The hard drive is encrypted using TrueCrypt (entire drive) and it would not allow me to copy anything onto the hard drive from the C Drive, or run a new database backup onto the hard drive. Some of the other things I was reading said that the hard drive might have been corrupt somewhere along the way, so I reformatted the drive and was able to run the backup on there after reformatting the drive. Why would it not allow me to run the backup (saying there was not enough space when there was clearly more than enough) until I reformatted the drive? Thanks.

more ▼

asked Jul 28, 2014 at 07:06 PM in Default

avatar image

11 1 1 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

A quick trip to truecrypt.sourceforge.net indicates that TrueCrypt has been abandoned - "WARNING: Using TrueCrypt is not secure as it may contain unfixed security issues" It's at least in a state of flux as others try to pick up the pieces.

Based on the statement "it would not allow me to copy anything onto the hard drive from the C Drive," I'd guess that the problem didn't have anything to do with SQL Server. SQL was just one more thing that didn't work with the encrypted drive.

You might try to find a TrueCrypt forum to see if you can find help with this.

more ▼

answered Jul 28, 2014 at 08:32 PM

avatar image

25k 3 13 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 28, 2014 at 07:06 PM

Seen: 724 times

Last Updated: Jul 28, 2014 at 09:01 PM

Copyright 2018 Redgate Software. Privacy Policy