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
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.
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.
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.
Are you sure of the IP? Try an nslookup servername or a ping -a servername
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
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.
when i execute nslookup it gives me physical ip and vrtual/cluster ip
