x

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
more ▼

asked Jun 19, 2011 at 02:44 AM in Default

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

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.

more ▼

answered Jun 19, 2011 at 05:36 AM

avatar image

Tim
40.8k 39 92 168

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jun 20, 2011 at 05:48 AM

avatar image

Blackhawk-17
12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

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

And a complete description is in a TechNet blog post by "Chuck Timon": File Share 'Scoping' in Windows Server 2008 Failover Clusters

more ▼

answered Jul 26, 2011 at 05:28 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

yes we are using

Jul 26, 2011 at 05:34 AM ramesh 1

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.

Jul 26, 2011 at 05:41 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jul 26, 2011 at 04:32 AM

avatar image

ramesh 1
2.2k 66 69 73

Are you sure of the IP?

Try an nslookup servername or a ping -a servername

Jul 26, 2011 at 05:28 AM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

when i execute

nslookup it gives me physical ip and vrtual/cluster ip

more ▼

answered Jul 26, 2011 at 11:05 PM

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2175
x85
x5

asked: Jun 19, 2011 at 02:44 AM

Seen: 1774 times

Last Updated: Jun 20, 2011 at 03:42 AM

Copyright 2017 Redgate Software. Privacy Policy