x

Create snapshot database error on remote server

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 we 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: I am 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.

more ▼

asked May 19, 2013 at 08:54 PM in Default

avatar image

SQLDBA123
240 12 18 19

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I would confirm the following are correct. 1. File system is truly NTFS and not FAT32 2. Log on to server and test creation locally. 3. Create a different folder and test creating Snapshot in new folder.

more ▼

answered May 21, 2013 at 11:43 AM

avatar image

sqlaj 1
5.5k 4 6

(comments are locked)
10|1200 characters needed characters left

It did not work on NAS storage. The project design changed and creatingthe snapshot on local disk.

more ▼

answered Jun 18, 2013 at 05:26 PM

avatar image

SQLDBA123
240 12 18 19

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x783
x15
x11

asked: May 19, 2013 at 08:54 PM

Seen: 1717 times

Last Updated: Jun 18, 2013 at 05:26 PM

Copyright 2018 Redgate Software. Privacy Policy