Posted by Erland Sommarskog on 08/16/07 22:00

Bill E. (billmiami2@netscape.net) writes:
> As it turns out, I was unable to restore the full backup because my
> drive was formatted using FAT and it appears that files over 4 GB are
> not supported with FAT, even though my total available disk space is far
> beyond 4 GB.
>
> I eventually had to do exactly what you suggested -- find a machine that
> would allow me to restore the full backup, shrink the logs and then
> create another backup that could be restored on my machine. This was
> certainly a pain but hopefully I won't have to do it again.

I don't want to be nosey, but I can't escape the comment that the
real problem is the FAT partition. I didn't think anyone still was
using that.

I would certainly look into a way to transfer that FAT partition to
NTFS.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: WHERE question
• Prev in forum: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
• Thread view: Re: Restore database with no log

[Reply to this message]