Hi Eugene,

It seems to me, that your server has a lack of storage, but for this problem 
there are
some interesting solutions available, which are officially supported by 
Microsoft since
the MS SQL Server 2000. I speak of FC SAN or ISCSI SAN volumes, which are also 
network based,
but which were intentionally designed for this purpose. The latter are very 
cheap compared
to FC SAN and have been evolved to a reliable and mature technique within the 
last 8 years.

Best regards,

Stefan Schank

you mssql data files are on a cifs share?  Is this supported by microsoft?

On Tuesday, June 2, 2009, GOKHAN ERTON <GOKHAN.ERTON AT lcwaikiki DOT com> 
wrote:

Hi,

I'd appreciate if anyone could tell me if it's possible to return mssql backups 
on a network share.

We are trying to run tests on a sun storage 7000 series and they do share the 
drives over CIFS, and Windows 2003 can see them as network shares.

I tried to return backups by using network path like 
\\servername\share<file:///\\servername\share> and mapping the share as drive, 
but none of them worked for me. I have to keep the datafiles on the network shares, 
cause sun insists on our using CIFS instead of iSCSI. We had a couple of controller 
failures on our iscsi attempts.

We are using networker 7.4.4 on both server and client side. Our networker user 
for sql server version is 5.2.0.71 on Windows 2003 environment.

We get an error as follows on each attempt:

Recovering files of client 'xxxxxx' from server 'xxxxxx.lcwaikiki.local' to 
client 'TEST1'.
43708:nsrsqlrc:Start time: Tue Jun 02 14:53:56 2009
43621:nsrsqlrc:Computer Name: TEST1     User Name: Administrator
                  NSR_CLIENT: xxxxxx;
                  NSR_SERVER: xxxxxx.local;
37725:nsrsqlrc:Recovering database 'Xxxxxx' into 'Xxxxxx' ...
4690:nsrsqlrc:RESTORE database [Xxxxxx] FROM 
virtual_device='Legato#ca398c60-3fe2-4a44-9c0d-1516a290cb99'  WITH move 
'Xxxxxx_Data' to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_21546.mdf', move 
'Xxxxxx_Data_2' to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_2_21546.ndf', move 
'Xxxxxx_Data_3' to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_3_21546.ndf', move 
'Xxxxxx_Data_4' to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_4_21546.ndf',
Reverse DNS lookup failed for host xxxxxx, 29085:nsrsqlrc:Microsoft SQL Server 
Provider error:
38006:nsrsqlrc:The file 
"\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_21546.mdf<file:///\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_21546.mdf>"
 is on a network path that is not supported for database files..
38006:nsrsqlrc:File 'Xxxxxx_Data' cannot be restored to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_21546.mdf'. Use WITH MOVE 
to identify a valid location for the file..
38006:nsrsqlrc:The file 
"\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_2_21546.ndf<file:///\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_2_21546.ndf>"
 is on a network path that is not supported for database files..
38006:nsrsqlrc:File 'Xxxxxx_Data_2' cannot be restored to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_2_21546.ndf'. Use 
WITH MOVE to identify a valid location for the file..
38006:nsrsqlrc:The file 
"\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_3_21546.ndf<file:///\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_3_21546.ndf>"
 is on a network path that is not supported for database files..
38006:nsrsqlrc:File 'Xxxxxx_Data_3' cannot be restored to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_3_21546.ndf'. Use 
WITH MOVE to identify a valid location for the file..
38006:nsrsqlrc:The file 
"\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_4_21546.ndf<file:///\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_4_21546.ndf>"
 is on a network path that is not supported for database files..
38006:nsrsqlrc:File 'Xxxxxx_Data_4' cannot be restored to 
'\\128.128.1.181\sqltest8kb\testfolder\Xxxxxx_Xxxxxx_Data_4_21546.ndf'. Use 
WITH MOVE to identify a valid location for the file..
38006:nsrsqlrc:The file 
"\\128.128.1.181\log\Xxxxxx_Xxxxxx_log_21546.ldf<file:///\\128.128.1.181\log\Xxxxxx_Xxxxxx_log_21546.ldf>"
 is on a network path that is not supported for database files..
38006:nsrsqlrc:File 'Xxxxxx_Log' cannot be restored to 
'\\128.128.1.181\log\Xxxxxx_Xxxxxx_log_21546.ldf'. Use WITH MOVE to identify a 
valid location for the file..
38006:nsrsqlrc:Problems were identified while planning for the RESTORE 
statement. Previous messages provide details..
38006:nsrsqlrc:RESTORE DATABASE is terminating abnormally..
37708:nsrsqlrc:nsrsqlado.cpp(2353): ExecuteFailed event arrived.
35867:nsrsqlrc:Error processing SQL database 'Xxxxxx'.
Internal error.

unknown XBSA error 1359 (0x54f)
43709:nsrsqlrc:Stop time: Tue Jun 02 14:56:03 2009

Restore completion time: Tue Jun 02 14:56:04 2009


Thanks in advance for your comments.

Gokhan Erton
Database Administrator
Tema Magazacilik Hizmetleri AS

________________________________

Bu e-posta mesaj? ki?iye ?zel olup, gizli bilgiler i?eriyor olabilir. E?er bu 
e-posta mesaj? size yanl??l?kla ula?m??sa, e-posta mesaj?n? kullan?c?ya hemen 
geri g?nderiniz ve mesaj kutunuzdan siliniz. Bu e-posta mesaj?, hi? bir 
?ekilde, herhangi bir ama? i?in ?o?alt?lamaz, yay?nlanamaz ve para kar??l??? 
sat?lamaz. Yollay?c?, bu e-posta mesaj?n?n vir?s koruma sistemleri ile kontrol 
ediliyor olsa bile vir?s i?ermedi?ini garanti etmez ve meydana gelebilecek 
zararlardan do?acak hi?bir sorumlulu?u kabul etmez.

The information contained in this message is confidential, intended solely for 
the use of the individual or entity to whom it is addressed and may be 
protected by professional secrecy. You should not copy, disclose or distribute 
this information for any purpose. If you are not the intended recipient of this 
message or you receive this mail in error, you should refrain from making any 
use of the contents and from opening any attachment. In that case, please 
notify the sender immediately and return the message to the sender, then, 
delete and destroy all copies. This e-mail message has been swept by anti-virus 
systems for the presence of computer viruses. In doing so, however, we cannot 
warrant that virus or other forms of data corruption may not be present and we 
do not take any responsibility in any occurrence

__________________________________________________________________________________________~TemaNetworks~____________________________________________________________________________________


To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the body of the email. Please write to networker-request 
AT listserv.temple DOT edu if you have any problems with this list. You can access the 
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the body of the email. Please write to networker-request 
AT listserv.temple DOT edu if you have any problems with this list. You can access the 
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER