question

ramesh 1 avatar image
ramesh 1 asked

Log Shipping in sql server 2008 using SAN Drive

hi Team, how to configure and implement Log Shipping in SAN Drive. we use SQL Server 2008 in WIndows 2008 environment.but wheni try to share a folder and access a shared folder , that folder is not accessed by its IP , `\\servername\foldername` it is accessed ,but when i try to accesss a the sharedfolder by using server ip ,it throws a error \\servername\foldername ----------acccessed \\192.192.192.192\foldername-------invalid folder not found
sql-server-2008log-shippingsan
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
Sounds like an OS issue. You may need to check firewall settings. Also if are trying to access the server by an alias you may need to research strict name checking and the loopback check if you will be accessing the share from the server the share is on. Something else to check would be to NTFS permissions. Even though you created the share you may not have rights to it. Server 2008 is much more strict about access than Windows 2003/2000.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image
Blackhawk-17 answered
Windows 95 could only map by name - not IP, but that was technologically eons ago. Can you try dropping to the command prompt and do the following tests: net view \\servername net view \\192.192.192.192 ping servername ping 192.192.192.192 tracert servername tracert 192.192.192.192 Let's see how networking at a low level is working.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image
ramesh 1 answered
net view \\\servername this command gives me the list of shared files in local drive net view \\\servername this command result me a error System error 53 has occured . tracert servername unable to resolve targer system name \\\servername we use windows server 2008 R2 ent edition as OS, with SAN drive.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are you sure of the IP? Try an nslookup servername or a ping -a servername
0 Likes 0 ·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Are you running a Failover Cluster? There is a nice question and answer related to this: [Forum FAQ: File Share “Scoping” in Windows Server 2008 Failover Clusters][1] And a complete description is in a TechNet blog post by "Chuck Timon": [File Share 'Scoping' in Windows Server 2008 Failover Clusters][2] [1]: http://social.technet.microsoft.com/Forums/en-US/winserverClustering/thread/705367d3-47bd-4aaa-a249-384aba702938/ [2]: http://blogs.technet.com/b/askcore/archive/2009/01/09/file-share-scoping-in-windows-server-2008-failover-clusters.aspx
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yes we are using
0 Likes 0 ·
So this is the case. Under failover cluster on Windows 2008 you cannot access the share using the IP address. Details you can find under links I have mentioned in my answer.
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
when i execute nslookup it gives me physical ip and vrtual/cluster ip
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.