Solved

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

Posted on 2013-06-07
7
360 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
  • 4
  • 3
7 Comments
 
LVL 83

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 83

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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

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 83

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 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