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?
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LMS Tracking Survey Result 1 52
About Wordpress website 3 118
Problem to get function 52 116
Search on a site 5 131
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…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

735 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