locked
Database snapshot in mirroring RRS feed

  • Question

  • Hi, When I take the snapshot of mirrored database in mirror server using the following code

    create database snap1 on (name=adventureworks_data,filename='d:\backup\adv.ss') as snapshot of adventureworks
    go

    I'm getting the below error

    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 "d:\backup\adv.ss" a sparse file. Make sure the file system supports sparse files.


    Thursday, March 15, 2012 1:20 PM

Answers

  • Make sure volume on which you are creating your Snapshot is formatted as NTFS and not FAT32


    • Edited by Chirag Shah Thursday, March 15, 2012 1:33 PM
    • Marked as answer by karthiksqldba Thursday, March 15, 2012 2:11 PM
    Thursday, March 15, 2012 1:33 PM
  • Exactly,

    You cannot create database snapshot on FAT32 file system or RAW partitions. The sparse files used by database snapshots are provided by the NTFS file system.

    Understand the minimum requirement and limitations for Database snapshot.

    http://msdn.microsoft.com/en-us/library/ms189940.aspx


    Please Vote & "Mark As Answer" if this post is helpful to you. Cheers Prakash Nandwana Bangalore , India


    Thursday, March 15, 2012 1:58 PM

All replies

  • Make sure volume on which you are creating your Snapshot is formatted as NTFS and not FAT32


    • Edited by Chirag Shah Thursday, March 15, 2012 1:33 PM
    • Marked as answer by karthiksqldba Thursday, March 15, 2012 2:11 PM
    Thursday, March 15, 2012 1:33 PM
  • Exactly,

    You cannot create database snapshot on FAT32 file system or RAW partitions. The sparse files used by database snapshots are provided by the NTFS file system.

    Understand the minimum requirement and limitations for Database snapshot.

    http://msdn.microsoft.com/en-us/library/ms189940.aspx


    Please Vote & "Mark As Answer" if this post is helpful to you. Cheers Prakash Nandwana Bangalore , India


    Thursday, March 15, 2012 1:58 PM