?
Solved

where are the default.aspx pages stored

Posted on 2010-11-19
4
Medium Priority
?
1,286 Views
Last Modified: 2012-05-10
Hi

I would like to know where the default.aspx pages of sharepoint are stored.

I need to know this because of the next situation:

I'm having a sharepoint where some custom changes have been made to the default.aspx pages. The problem is that those custom changes weren't that good and the whole pages are screwed up...

I'm wondering if it's possible to just detach the db of sharepoint, set up a new web application and attach the db to that new web application. Is that a possibility to get the standard aspx back or are those stored in the db (and the db detach and attach method won't change a thing)

thanks in advance

kind regards
0
Comment
Question by:techneitsolutions
[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
  • 2
4 Comments
 
LVL 6

Expert Comment

by:ramuar1981
ID: 34171955
default.aspx page database path is

open the webapplication database in database server -> open dbo.AllLinks -> columan name is "[LeafName]"

other wise run this query in the database

SELECT TOP 1000 [SiteId]
      ,[DeleteTransactionId]
      ,[DirName]
      ,[LeafName]
      ,[WebPartId]
      ,[FieldId]
      ,[LinkNumber]
      ,[TargetDirName]
      ,[TargetLeafName]
      ,[Type]
      ,[Security]
      ,[Dynamic]
      ,[ServerRel]
      ,[PointsToDir]
      ,[Level]
      ,[Search]
  FROM [WSS_Content_database name].[dbo].[AllLinks]
0
 
LVL 9

Accepted Solution

by:
irinuc earned 2000 total points
ID: 34172085
Hi,

please keep in mind that running any query on the database will get you of any support MS could provide. It is highly discouraged to interogate database and to change it without MS looking over your shoulder is a big "DON'T".

From my experience the detach will do nothing; the change is stored in the database, so it will not solve your issue. You'll need to track the change, and if it is on the page, solve it on the page, if it is on the masterpage, then solve the masterpage (this assuming you have wss 3)

The defaul.aspx page is almost always stored on the root. That is, if you would open the site http://sitename with Designer or Frontpage (depending on what is supported by your environment), you will find it in the main page that opens. If Designer is supported, you can right click on the page and select "Reset to site definition" and that will remove any customizations (better do a copy before this operation, just in case).

hope this helps
0
 
LVL 6

Expert Comment

by:ramuar1981
ID: 34172141
Hi irinuc,

your comment is correct. my post is for only showing the default.aspx page in database.

techneitsolutions-> you want to change any thing and customization in default.aspx page open that site in sharepoint designer and that will show the default.aspx page R.C and open the file and you can edit the default.aspx page
default-page.jpg
0
 
LVL 7

Expert Comment

by:luceysupport
ID: 34172310
You should open your site in sharepoint designer and then open the default.aspx page.

This will give you more info on what is causing the problem and you should be able to fix the issue also.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

764 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