I think, even if you achieve to restore it to network path, MS SQL fails
with unsupported cifs usage.
It seems to me that fixing iscsi issue will be more practical. Please note
that iSCSI must be supported by your storage. If you are using iSCSI
adapter, you can try microsoft iSCSI initiator as an alternate.
Worse case you can attach some external usb disk just to achive this
restore:)) (of course it will be very slow)
On Tue, Jun 2, 2009 at 4:32 PM, 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
|
