sigme


hello all

I am unable to read the mirrored database as it is always in the restoring state.
I have used only two servers (principal and mirror no witness server)
I tried to create the snapshot of the mirrored database but i get the following errors:

Code Snippet

Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 5119, Level 16, State 1, Line 1
Cannot make the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CRO_MASTER_data_1800.ss" a sparse file. Make sure the file system supports sparse files.


How can i get rid of this problem






Re: problem in reading the mirrored databse

Peter Byrne MSFT


It looks like your C: drive might be FAT or FAT32. Sparse files require NTFS.