Re: [Networker] Returning MSSql backup on a network share

Thank you for your replies.

Actually sun insists on the usage of cifs because we are gonna test the 
performance of the new sun 7000 series that run on SATA and SSD hard disk and 
compare it with our current storage EMC CX4-480. They said controller software 
can generate more detailed performance reports when CIFS is used. So we wanted 
to follow their advice as this is a test environment not a production one.

And the problem was solved by adding a start up parameter to the MSSQL service. 
So in our situation, it was not networker(7.4.4) not to restore backups on 
network shares but sql server engine. I include this for future reference.

Startup parameter for MSSQL service to run on data files located on network 
shares is: -T1807
It was added to the startup parameters through sql server configuration manager.

Gökhan Erton

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On 
Behalf Of Abad Uriarte, Arkaitz
Sent: Wednesday, June 03, 2009 9:51 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Returning MSSql backup on a network share

hello;

We known in AIX with  7.3.3 client version of networker, the cifs
mounted partition is save in backups (is a bug). I think in 7.4 is
resolved.

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


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