Recreate Personal Site for a user in Sharepoint portal server 2003

Posted on 2004-08-06
Last Modified: 2013-12-24
I am one of the administrator of our SPS and one of our users modified their 'My Site' with frontpage and it got messed up too much.

Is there a way to recreate the site or restore to a default my site.
Currently, his page has no 'Modify my page' or 'Actions' list.

I would definitely appreciate any help on this.
Question by:girishraja
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
LVL 29

Expert Comment

ID: 11742521
Did you have a back up copy somewhere on your local HD?  You could try to contact your hosting company to see if they had a backup, but they might charge quite a bit :-/

LVL 12

Expert Comment

ID: 11747564
Do you have another "My Site" of some other user you can just copy over the messed up site and then make some minor changes to make it specific to the user that decided to mess it up?


Author Comment

ID: 11748856
How do I copy over a site of someone else and change it for the current user?
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

LVL 12

Expert Comment

ID: 11749431
Excuse me but I read this question a little to quick. To fix this you are going to have to delete the user. The problem is the site is actually stored in SQL so all of the individual user's data is stored in the database. In order to correct this the best route is to delete the user and then recreate the user. This will set the user back to default values. I recommend downloading any files that are associated with the user so he/she will be able to upload them after the recreation.


Author Comment

ID: 11752897
Deleting the user is not possible.
There are so much of postings and documents made by the user.

Can't I delete the row pertinent to his site from the database?
LVL 12

Expert Comment

ID: 11754526
Yes you can if you have sql enterprise manager. This is a very scary area and if you are not real familiar with this operation I caution you with proceeding.

There are numerous tie-ins to other areas associated with the user that even deleting his/her web settings may remove the tie ins to the documents.


Author Comment

ID: 11755265
I do have the SQL enterprise manager.

But what are the related tables for it.
Can anyone help me with the list of queries I need to run to get it done.

Or is there a better way to do it.

I am sure that 'My Site' is not created when you add a user.
Only when the user clicks on 'my site' for the first time, it creates the site.

Accepted Solution

vinayakrishna earned 50 total points
ID: 11940608

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following:…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

696 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