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