hello;

Arkaitz
----------------------------------------------------------------------
ARKAITZ ABAD URIARTE

Euskal Herriko Unibertsitatea              Email: arkaitz.abad @ehu.es
Bizkaiko I.I.S.I.G                         Tel. : 94 601 8390
----------------------------------------------------------------------
Aurreztu papera. E-posta hau inprimatu beharra daukazu?



"Smith, Al" <Al.Smith AT TIMET DOT COM> ha escrito:

by default networker ignores cifs shares just like nfs mounted
volumes. the volume or disk presented must appear to be local to the
client.

On Jun 2, 2009, at 18:31, "Eugene Vilensky" <evilensky AT GMAIL DOT COM> wrote:

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

--
Regards,
Eugene Vilensky
evilensky AT gmail DOT com

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

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