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
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?
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.

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Visual Source Safe 2005 on Windows Server 2012 R2 10 1,338
ASP.NET Fix Column Width 7 192
Serif Plus workable? 4 44
Ezidebit payment gateway 5 80
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…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and Log…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…

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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now