SharePoint How to

SharePoint How to

SharePoint Services Provider How to

Microsoft SharePoint and WSS Issues

Assign permissions on the discussion in WSS
Can I install My Site in WSS 3
Can I install WSS on Windows 2008?
Can we share files with outside clients using SharePoint?
Connecting SharePoint to UNC Network Shares
How do I know someone is also editing a SharePoint Document - Step by step with screenshots
How to access SharePoint and upload/save multiple files
How to add a user to access SharePoint
How to add SharePoint to Outlook
How to assign permissions on Microsoft SharePoint
How to assign permissions in SharePoint
How to assign permissions in sub-folder in SharePoint
How to assign permissions to Anonymous Users in SharePoint
How to backup SharePoint
How to change name in SharePoint Link Bar
How to change SharePoint IP to DNS name
How to configure Antivirus on SharePoint
How to configure permissions on SharePoint
How to configure list and library settings

How to convert a Web Site to SharePoint site
How to create and configure My Site
How to create a site content
How to create a new user in SharePoint Site
How to Create a Project Page in Office SharePoint Server 2007
How to create a SharePoint Site
How to create a team site in SharePoint
How to delete/remove a user from SharePoint
How to edit Links in SharePoint
How to edit permissions in SharePoint Folder
How to enable Anonymous Users in SharePoint
How to Enable SharePoint Versioning
How to map SharePoint Folder as a network location
How to modify the inherits permissions in SharePoint 2007
How to migrate WSS 2 to MOSS 2007
How to modify SharePoint top link bar
How to Modify users in Shared Service Administration
How to Move all Databases from C: to D:
How to move Office SharePoint Server 2007 Data from C to D

How to Shrink a File (using SQL Server Management Studio

How to uninstall WSS V3

How to move the Web application from one server farm to the other
Installing Office SharePoint Server 2007 on Windows Server 2008
Is it possible to transfer files from one site to another?

Is it possible to give permission to a single document?
Prevent inheriting permission from SharePoint parent site

System requirements for SharePoint Services 3

Top 5 Benefits of SharePoint Services
Move WSS content database to a different drive with SSEE

Move WSS content database to a different drive with SSEE using SQL Server Management Studio Express
Troubleshooting SharePoint by using GUID
What are different between WSS and MOSS

Windows SharePoint

WSS v3 vs MOSS 2007

How to backup SharePoint

There are many methods to backup SharePoint. You can use HTML Administration pages to back up and restore the data in the database, and also to schedule automatic backups for regular intervals

A. Using HTML Administration Pages to Back Up and Restore Data

To create a database backup by using HTML Administration pages
1. On the server computer, click Start, point to Programs, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. On the Central Administration page, in the left pane click on Operations.
3. Under the Backup and Restore, click on Perform a Backup.
4. On the Select Component to Backup, check what you want to backup.
5. Click Continue to Backup Operations to start the backup.
You can restore the database backup from the same Database Backup and Restore page.

To restore a database backup by using HTML Administration pages
1. On the server computer, click Start, point to Programs, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. On the Central Administration page, in the left pane click on Operations.
3. Under the Backup and Restore, click on Restore from Backup.
4. On the Select Backup Location, browse to the location you backup before..
5. On the Select Backup to Restore, check what you want to restore.

6. Click Continue Restore Process to start the restore.

Backup SharePoint Automatically

You can also schedule an automatic backup of your database from the Schedule Database Backup administration page.
To automatically back up the database
1. On the server computer, click Start, point to Programs, point to Administrative Tools, and then click Microsoft SharePoint Administrator.
2. On the Server Administration page, next to the virtual server that contains the data that you want to back up, click Administration.
3. On the Virtual Server Administration page, click Schedule database backup.
4. Next to Automatic database backups are, select On.
5. Under Automatic database backups occur, select Daily, Weekly, or Monthly.
6. If you selected Daily, in the Time box, select the time of day to perform the backup.
– or –
If you selected Weekly, in the Time box, select the time of day, and then in the Weekday box, select the day of the week to perform the backup.
– or –
If you selected Monthly, in the Day box, select the day of the month, and then in the Time box, select the time of the day to perform the backup.
7. Click Submit.
Top Of Page
Using the Command-Line Tools to Back Up and Restore Data

You can use the command line to back up and restore the database either locally, by using Owsadm.exe, or remotely, by using Owsrmadm.exe. To back up the database from the command line, you use the BackupDB operation. To restore, you use RestoreDB. The BackupDB operation takes the optional parameters –filename, -port, and –schedule. To do a simple backup of the database on port 80, you would use the following syntax:
Owsadm.exe –o backupdb –p 80 –f path/filename
The RestoreDB operation takes the optional –filename and –port parameters. To perform a simple restore of the same database, you would use the following syntax:
Owsadm.exe –o restoredb –p 80 –f path/filename
You can also back up the database automatically, by creating a scheduled job for the backup process. To schedule automatic backup you use the BackupDB operation with the schedule parameter, and specify a time/day/month/year to back up the database.
Note The SharePoint Timer Service is not available for FrontPage 2002 Server Extensions on the Windows Server 2003 family platform. For that environment, you must back up the database manually, rather than scheduling automatic backups. If you want to automate the backup process, you can do so by including the backup command-line string in a batch file or script.
The following example syntax shows how to set the database to be backed up every Monday at 11:59 P.M. for port 80.
owsadm –o backupdb –p 80 –schedule "weekly at Mon 23:59"
For more information about specifying the times to use for backing up the database, see Scheduling Timed Jobs.

Post your questions, comments, feedbacks and suggestions

Contact a consultant