Pages

Sharepoint Server 2007 Backup & Restore

Posted On Saturday at at 6:36 PM by VM  

Back up a farm by using Central Administration:

 

1.        On the SharePoint Central Administration Web site, on the Operations page, in the Backup and Restore section, click Perform a Backup.
2.        On the Select Component to Backup page, select Farm, and then click Continue to Backup Options.
3.        On the Select Backup Options page:
a.        In the Backup Content section, ensure that Farm is displayed.
b.       In the Type of Backup section, select Full.
c.        In the Backup File Location section, type the Universal Naming Convention (UNC) path to the backup folder.
4.        Click OK.
You can view the backup job status on the Backup status page by clicking Refresh. The page also refreshes every 30 seconds automatically. Backup and recovery are Timer service jobs, so it may take few seconds for the backup to start.
If you receive any errors, you can find more information by looking in the spbackup.log at the UNC path that you specified in step 3.
Restore a farm by using the SharePoint Central Administration Web site:

1.        On the SharePoint Central Administration Web site, on the Operations page, in the Backup and Restore section, click Restore from Backup.
2.        On the Select Backup Location page, in the Backup File Location section, type the Universal Naming Convention (UNC) path to the backup folder.
3.        On the Select Backup Package to Restore page, select the backup file you want to use to restore, and then click Continue Restore Process.
4.        On the Select Component to Restore page, select the farm you want to restore, and then click Continue Restore Process.
5.        On the Select Restore Options page:
a.        In the Restore Component section, Ensure that Farm is displayed.
b.       In the Restore Options section, select Same configuration.
A message is displayed, notifying you that the current farm will be overwritten. Click OK.
c.        In the Login Names and Passwords section, type the user name and password for your Farm Administrators account.
d.       In the New Names section, type new names and URLs for each component, or accept the default values.
e.        Click OK.
Back up an Office SharePoint Server 2007 farm using SQL Server

1.        Start SQL Server Management Studio and connect to the database server.
2.        In Object Explorer, expand Databases.
3.        Right-click the configuration database (usually named SharePoint_Config), point to Tasks, and then click Back Up.
4.        In the Back Up Database dialog box, select the type of backup that you want to perform from the Backup type list. For more information about which backup type to use, 
5.        Under Backup component, select the Database option.
6.        In the Name text box, type a name or use the default.
7.        In the Description text box, type a description of the backup.
8.        Under Backup set will expire, specify how long the backup should be kept, or use the default. When the backup set expires, the backup set can be overwritten by any subsequent backups with the same name. The backup set is set to never expire (0 days) by default.
9.        In the Destination section, specify a location to store the backup set, or use the default.
10.     Click OK to back up the database.
11.     Repeat steps 3 through 10 for the following databases:
·         Content databases
·         Databases for Shared Services Providers (SSPs)
·         Search databases for the SSPs
·         Search databases
Note:

The search index is not stored in SQL Server. If you use SQL Server 2005 tools to back up search, you must perform a full crawl upon recovering the database. 

Schedule a delayed or recurring backup

1.        In the Backup database dialog box, after you have entered the database backup information (see the Backup a server farm procedure earlier in this article), click the arrow to show the Script menu, and then click Script Action to Job.
2.        In the New Job dialog box, in the Select a page pane, click Schedules, and then click New.
3.        In the New Job Schedule page, specify a name, type, frequency, and duration that you want for the scheduled backup, and then click OK.
4.        Click OK to accept the scheduled job changes.
5.        Click OK to save the job changes and start the database backup.

To schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005, follow these steps:
  1. Start SQL Server Management Studio.
  2. In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list.
  3. Click Connect. In Object Explorer, expand Databases.
  4. Right-click the database that you want to back up, click Tasks, and then click Back Up.
  5. In the Back Up Database - DatabaseName dialog box, type the name of the backup set in the Name box, and then click Add under Destination.
  6. In the Select Backup Destination dialog box, type a path and a file name in the Destinations on disk box, and then click OK.
  7. In the Script list, click Script Action to Job.
  8. In the New Job dialog box, click Steps under Select a page, and then click Edit if you want to change the job parameters.
    Note In the Job Step Properties - 1 dialog box, you can see the backup command.
  9. Under Select a page, click Schedules, and then click New.
  10. In the New Job Schedule dialog box, type the job name in the Name box, specify the job schedule, and then click OK.
    Note If you want to configure alerts or notifications, you can click Alerts or Notifications under Select a page.
  11. Click OK two times.You receive the following message: The backup of database 'DatabaseName' completed successfully.
Note To verify the backup job, expand SQL Server Agent, and then expand Jobs. When you do this, the SQL Server Agent service must be running.
Restore an existing database using SQL Server

1.       If the Windows SharePoint Services Timer service is running, stop the service and wait for a few minutes for any currently running stored procedures to complete. Do not restart the service until you have restored all the databases that you need to restore.
2.       Start SQL Server Management Studio and connect to the database server.
3.       In Object Explorer, expand Databases.
4.       Right-click the database that you want to restore, point to Tasks, point to Restore, and then click Database.
The database is automatically taken offline during the restore operation and cannot be accessed by other processes.
5.       In the Restore Database dialog box, specify the destination and the source, and then select the backup set or sets that you want to restore.
The default values for destination and source typically suit most recovery scenarios.
6.       In the Select a page pane, click Options.
7.       In the Restore options section, select only Overwrite the existing database. Unless your environment or policies require otherwise, do not select the other options in this section.
8.       In the Recovery state section:
·         If you have included all the transaction logs that you must restore, select RESTORE WITH RECOVERY.
·         If you must restore additional transaction logs, select RESTORE WITH NORECOVERY.
·         The third option, RESTORE WITH STANDBY is not used in this scenario.
9.       Click OK to complete the restore operation.
10.   Repeat steps 4 through 9 for each database that you are restoring.
11.   Start the Windows SharePoint Services Timer service.

Posted in |

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)