none
Create snapshot database error on remote server

    Question

  • Environment:

    OS: Windows 2008 R2
    SQL Server : 2008 R2 EE
    Shared NAS storage: NTFS (\\RemoteServerName\SharedFolderName)
    Permisisons on Shared folder: Full control
    Source DB model: Full recovery.

    Snapshot DB Script:

    CREATE DATABASE TestDB_Snapshot1 ON ( NAME = TestDB_data, FILENAME ='\\RemoteServerName\SharedFolderName\TestDB_Snapshot1.ss')
    AS SNAPSHOT OF TestDB
    GO

    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 2, Line 1
    Cannot make the file "\\RemoteServerName\SharedFilderName\TestDB_Snapshot1.ss" a sparse file.
    Make sure the file system supports sparse files.


    Questions

    1. Can't create snapshot database on remote server location if NTFS filesystem? Seen in below MS KL limitations, FAT32 not support snapshot databases. But our storage is NTFS filesystem(NAS storage). http://msdn.microsoft.com/en-us/library/ms175158.aspx#Prerequisites
    2. Any suggestion to create snapshot on NAS storage area wihtout any sparse files errors?
      Note: Able to create snapshot database if it is local disk on the server and
      not able to create if it remote server shared location

    Thanks in advance.


    • Edited by SQLDBA321 Monday, May 20, 2013 1:16 AM
    • Moved by Kalman Toth Monday, May 20, 2013 8:09 AM Not t-sql
    Monday, May 20, 2013 1:13 AM

All replies

  • Hello,

    Can you try to change the SQL Server service account to a domain account and grant full premission to the domain account on the shared folder?

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Tuesday, May 21, 2013 8:59 AM
    Moderator