Solved

Update Links in Office Docs Pointing to an Old File Server (UNC)

Posted on 2013-06-07
7
363 Views
Last Modified: 2013-08-25
Hello,
One of my customers is using Excel docs to reference other files relating to a specific case via links created inside the Excel doc. The link point to \\oldserver\publicstorage\etc\etc. I am planning to move the cases folder to a new server with larger storage over the weekend, which means that those links will stopped working. The new address will be \\newserver\cases\etc\etc.

 Is there a way to create a link between the two addresses so that all those hundreds on links/ files will not need to be updated manually?

Thanks for your help.
0
Comment
Question by:SpiderPig
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 84

Expert Comment

by:oBdA
ID: 39229798
On the new server, create the "DisableStrictNameChecking" key as described here (yes, it's still valid for 2008):
Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name
http://support.microsoft.com/kb/281308
Then once the data is on the new server, either
* rename the old server if you still need it, or
* shut the old server down for good and delete the old computer account from AD.
Then you can create a new static DNS host entry with the old server's name and the new server's IP address.
0
 

Author Comment

by:SpiderPig
ID: 39229815
O.K so both servers will remain active for another 2-3 years... Does that change anything? What is DisableStrictNameChecking? Where is it?
0
 
LVL 84

Expert Comment

by:oBdA
ID: 39229869
The "DisableStrictNameChecking" is in the registry as described in the link above. It allows a server to respond to requests made for a name other than its host name.
So you can either
* move everything that absolutely requires to be found under the old server's name and shares onto the new server, rename the old one, and then create the static DNS entry (or, of course, rename the new server to the old server's name if that's an option), then change anything that still requires access to the old server to point to the new name of the old server, or
* Keep the old server with its original name, and create a script that automatically opens all Excel files and replaces the occurrences of the old name with the new one.
Seeing as you want to do this pretty soon, you won't have enough time to reliably develop and test the script required for the latter.
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:SpiderPig
ID: 39230028
Not to mention how to do something like that... blah...

Shoot so no other options for me?
0
 
LVL 84

Expert Comment

by:oBdA
ID: 39230124
None that I can think of, sorry; you can't just redirect a shared folder to another shared folder in the way required for your scenario.
If it's just about storage space (and not the general performance of the old server), you could attach more "real" storage to the old server and then mount the additional storage as the "Cases" folder.
0
 

Accepted Solution

by:
SpiderPig earned 0 total points
ID: 39425026
I guess I was dealing with relative links, which didnt include specific server name but rather a ...\ file or something strange like that. So when I move the files the links for updated auto. Not sure how but it worked, but it did.

Thank you all for the prompt response and my apologies for the delay.
0
 

Author Closing Comment

by:SpiderPig
ID: 39436759
None of suggested solutions worked. At the end a simple robocopy (robocopy source destination *.* /COPYALL /DCOPY:T /E) worked.
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question