FAT32->NTFS (after SQL Server 2005 Express installation)

I have FAT32 system on my machine and SQL Server 2005 Express installed on it.

Is there will be any problem in SQL Server 2005 Express (in terms of server machine and client machine) if I change my FAT system from FAT32 to NTFS ?

Thanks

Typically you have to format your drive to switch file systems. You'd have to re-install all your software after this, including SQL Express. If you have user databases, you'll need to save copies of them somewhere before formating your disk. Once you've got the system switched over to NTSF, SQL Express will work fine.

If you're using a third party tool to switch file systems without formating, I can't make any claims as to what will happen with SQL Express as we don't test that.

Mike

|||

Thanks Mike.

For unexpacted I should go through Format HDD (or partiation) as NTFS system -way.

FAT32 and Status 112

Howdy - -
Is there some kind of problem backing up to FAT32? We have a HUGE
drive, and we get a write failure (status = 112) even though there is
way more than enough space for the backup.
Any ideas?
- - Herb
FAT32 limits file sizes to 4GB. We had this problem with some filegroups
that filled up
even though the disks had adequate space.
"Herb Ray" <herb@.ad-co.com> wrote in message
news:ukhUe.15$yu1.325681@.news.sisna.com...
> Howdy - -
> Is there some kind of problem backing up to FAT32? We have a HUGE
> drive, and we get a write failure (status = 112) even though there is
> way more than enough space for the backup.
> Any ideas?
> - - Herb
|||Armando Prato wrote:
> FAT32 limits file sizes to 4GB. We had this problem with some filegroups
> that filled up
> even though the disks had adequate space.
> "Herb Ray" <herb@.ad-co.com> wrote in message
> news:ukhUe.15$yu1.325681@.news.sisna.com...
>
>
Armando - -
Thanks for your reply. That sounds like it's our problem.
- - Herb

FAT32 and Status 112

Howdy - -
Is there some kind of problem backing up to FAT32? We have a HUGE
drive, and we get a write failure (status = 112) even though there is
way more than enough space for the backup.
Any ideas?
- - HerbFAT32 limits file sizes to 4GB. We had this problem with some filegroups
that filled up
even though the disks had adequate space.
"Herb Ray" <herb@.ad-co.com> wrote in message
news:ukhUe.15$yu1.325681@.news.sisna.com...
> Howdy - -
> Is there some kind of problem backing up to FAT32? We have a HUGE
> drive, and we get a write failure (status = 112) even though there is
> way more than enough space for the backup.
> Any ideas?
> - - Herb|||Armando Prato wrote:
> FAT32 limits file sizes to 4GB. We had this problem with some filegroups
> that filled up
> even though the disks had adequate space.
> "Herb Ray" <herb@.ad-co.com> wrote in message
> news:ukhUe.15$yu1.325681@.news.sisna.com...
>
>
>
Armando - -
Thanks for your reply. That sounds like it's our problem.
- - Herb

FAT32 and Status 112

Howdy - -
Is there some kind of problem backing up to FAT32? We have a HUGE
drive, and we get a write failure (status = 112) even though there is
way more than enough space for the backup.
Any ideas?
- - HerbFAT32 limits file sizes to 4GB. We had this problem with some filegroups
that filled up
even though the disks had adequate space.
"Herb Ray" <herb@.ad-co.com> wrote in message
news:ukhUe.15$yu1.325681@.news.sisna.com...
> Howdy - -
> Is there some kind of problem backing up to FAT32? We have a HUGE
> drive, and we get a write failure (status = 112) even though there is
> way more than enough space for the backup.
> Any ideas?
> - - Herb|||Armando Prato wrote:
> FAT32 limits file sizes to 4GB. We had this problem with some filegroups
> that filled up
> even though the disks had adequate space.
> "Herb Ray" <herb@.ad-co.com> wrote in message
> news:ukhUe.15$yu1.325681@.news.sisna.com...
>>Howdy - -
>>Is there some kind of problem backing up to FAT32? We have a HUGE
>>drive, and we get a write failure (status = 112) even though there is
>>way more than enough space for the backup.
>>Any ideas?
>>- - Herb
>
>
Armando - -
Thanks for your reply. That sounds like it's our problem.
- - Herb