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
|