Where does Sharepoint Services 2.0 store its files? 1

[programerrusuk]

I was wondering for a back where exactly sharepoint stores the web files (not the admin), such as the actual site?
Any help would be useful

 

[tdacquisto]

It depends on what backend you're using. SQL or Non-sql.

If you're using SQL, it's all contained in an SQL Server database. Not sure where it is if you're not using SQL Server as the backend.

Tom.

 

[programerrusuk]

it did install SQL Desktop manager, so where would I locate and save the site?
Thanks

 

[Thomas2000]

Hello,

Nor sure if this really answer your question, but wss has two databases, Content database and Configuration database. Easiest way to save (backup) a site is to use the built in tools stsadm or smigrate.

Example how To backup (save) a sitecollection (including subsites) use:

stsadm.exe -o backup -url

http://yoursite

-filename D:\backup\nameofbackupfile.bak

The above will backup everything in a site collection (including security settings like user permissions). The staadm will not allow you to just backup a single subsite, it works on site collection level.

To backup a single site SMIGRATE allows you to for example backup as subisite wihtin a site collection.

Example how to backup (save) a site with SMIGRATE
smigrate.exe -w

http://yoursite

-f d:\backup\nameofbackupfile.fwp -u domain\username -pw yourpassword

To exclude subsites use -e

SMIGRATE does not backup security settings like user rights. You need to be a site administrator to use smigrate (might be a good idea to use an account that is an administrator on the server). And if Internet Explorer enhanced security is enabled on the server you must use the -u -pw option. Also might be a good idea to add the site to your Local Intranet Security zone in Internet Explorer.

To try and save a site by looking at the databases would probably be very hard since everything is stored in different tables in the configuration and content database.

Regards,
Thomas

 

[programerrusuk]

This is what I am looking for, so would I use a command promt for this?

 

[programerrusuk]

If i were to then want to transfer this site how would I then upload it elsewhere?

 

[Thomas2000]

Hello,

Yes you will use the command prompt.

To restore the site to a different location create a new empty site (if you create a new site from the Central Administration pages then you should abort the site creation when you come to the step where you are asked to chose a site template e.g. Team website, Documnet Worskpace)

Example with smigrate you use the following:
smigrate.exe -r -w

http://yournewEMPTYwebsiteurl

-f d:\backup\nameofbackupfile.fwp -u doman\username -pw yourpassword

The above does not migrate user-rights so any users would have to be entered again.

Example with stsadm you use the following:

stsadm.exe -o restore -url

http://yourEMPTYwebsiteurl

-filename d:\nameofbackupfile.bak

It is important that the site you want to restore TO is empty you can also create this empty site via a command line.

Check the Windows SharePoint Services Administraiton guide and the SharePoint Portal administration guide from Microsoft, they should have all the operations you can perform with stsadm and smigrate.

Regards,
Thomas

 

[programerrusuk]

Thanks alot, this is perfect.

 

[arol]

!!!can I use the stsadm or smigrate to migrate sharepoint databases to a new server.
Is there anything else I need to do

 

[programerrusuk]

You should be able to as this will copy any secuity, files and the subsutes. You would just run what is mentioned earlier in the thread about saving and loading.