- If the Windows SharePoint Services Timer service is
running, stop the service and wait for several minutes for any currently
running stored procedures to finish.
- Do not restart the service until after you restore the
content databases.
- Open SQL Server Management Studio
- Connect to the database server.
- Right-click the Database
that you want to restore > Tasks
> Restore > Database.
- 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.
- In the Select a page pane, click Options.
- In the Restore options section, select only Overwrite
the existing database.
- In the Recovery state section:
- If you have included all the transaction logs that you
must restore, select RECOVER WITH RECOVERY.
- If you must restore additional transaction logs, select
RECOVER WITH NORECOVERY.
- The third option, RECOVER WITH STANDBY is not
used in this scenario.
- Click OK to complete the recovery operation.
- Repeat steps 4 through 10 for each database that you are
restoring.
- Start the Windows SharePoint Services Timer service.
Saturday, June 9, 2012
How to restore content database using SQL server in SharePoint 2010 ?
Subscribe to:
Post Comments (Atom)
Popular Posts
-
This is the method, I followed to achieve – add image to custom list with calculated / conditional column. Following is the result list... -
if you want to do a User profile import in SharePoint 2010.. you should have the 'User Profile Synchronization Service' started.... -
SharePoint provides you “Export to Spreadsheet” feature across almost all list, allowing you to export your list content to Excel. But no...
-
Note: A LOT of these questions are specific to SharePoint 2007, and won't have applicability for SharePoint 2003! 1) What are the...
-
A very common & known issue while migrating IE versions. There is couple of steps and checking should be done to get this resolved. ...
-
I found this really great article that talks in depth as well in an easy language about the new options of under look and feel of 2013. h...
-
The April 2015 Cumulative Update for SharePoint 2010 has been released. SharePoint Foundation: https://support.microsoft.com/en-us/kb...
-
We love virtual labs they are free, non hassle and disposable ways to work around SharePoint deployment SharePoint 2010 virtual lab can be...
-
The April 2015 Cumulative Update for SharePoint 2013 has been released. SharePoint Foundation: http://support.microsoft.com/kb/29652...
-
June 2014 Cumulative Update for SharePoint 2013 has been released. SharePoint Foundation - KB2881063 http - //support.microsoft.com/kb...
No comments:
Post a Comment