SharePoint Restore Error
shannon
I am trying to restore a share point backup to a restore site and database
without success. I have done it in the past and it worked perfectly. I am
following the same instructions I did last time.
C:\Documents and Settings\Administrator>"c:\program files\common
files\microsoft
shared\web server extensions\60\bin\stsadm.exe" -o createsiteinnewdb -url
http:
//companyweb/sites/restore2 -ownerlogin domain\ADMINISTRATOR -owneremail
admini...@domain.local -databasename STS_RESTORE2
Operation completed successfully.
C:\Documents and Settings\Administrator>"c:\program files\common
files\microsoft
shared\web server extensions\60\bin\stsadm.exe" -o restore -url
http://companyw
eb/sites/restore2 -filename "d:\shareptbackup\restoreweb.bak" -overwrite
Cannot complete this function.
When I go to the restore site the message on the page is The Web site that
is referenced here is not in the configuration database. The only thing I
can possible see is that I cannot manage the front page extensions. When I
go to share point administrator and click on the companyweb the page cannot
be found and it’s not in iis. I already have the latest version 6.0.2.6411.
I have searched the knowledge base and made sure the timer service is
running. Any suggestions would be greatly appreciated.
Jenny wu [MSFT]
Thanks for posting here.
For you description, I understand that you have suffered a restore issue.
if I am off base, please don't hesitate to let me know.
Based on my research, it''s a SBS 2003 WSS disaster recovery issue. I think
you could refer to the following article to perform a disaster recover for
Companyweb.
827701 How to perform a disaster recovery operation of SharePoint Services
http://support.microsoft.com/?id=827701
In addition, the following information may also be useful to you.
829113 How to restore a Windows SharePoint Services CompanyWeb database
after
http://support.microsoft.com/?id=829113
829112 How to back up and restore http://companyweb data in Windows Small
http://support.microsoft.com/?id=829112
For your convenience, I would like to show you the detail steps to
implement a WSS disaster recovery:
Prerequisites
==================
These steps must be used when you cannot restore the System State on the
original server from Backup. For these steps to work it requires that new
server have the same domain name as the original server where the backup of
the database and log files was performed. The required database and logs
files are listed below:
- STS_Config.mdb
- STS_Config_log.mdf
- STS_Servername_1.mdf
- STS_Servername_1_log.ldf
Before you can start the restore of the SharePoint Services databases, all
of the critieria below must be met:
- You must have Small Business Server 2003 (SBS 2003) with the Intranet
component installed.
- the SharePoint Services CompanyWeb must be working with a new, unmodified
database.
- The SharePoint Services CompanyWeb Web site must be accessible
(http://companyweb).
Restore the SBS 2003 SharePoint Services Databases
==================
This article includes the steps neccessary to restore any additions made to
the default SharePoint Services installation. This includes any top-level
SharePoint sites that must be created and additional data files.
specifically, steps preceded with ** must be followed to restore any
additions made to the default SharePoint services installation. If you
restore only the default SharePoint databases with no modifications; ignore
any steps that are preceded with **:
1. Verify that SharePoint Services CompanyWeb Web site is accessible
(http://companyweb).
2. **Create any additional top-level Web sites that existed on the old
server with IIS. These are the Web sites that are located outside the
Companywebs virtual server top level SharePoint site.
3. **Create DNS host records for any additional top-level SharePoint sites
that existed on the old server.
4. Stop MSSQL$SharePoint service.
a. "Click "Start", and then click "Run""
b. In the "Open" box, type "cmd", and then click "OK".
c. At the command prompt, type "net stop msql$sharepoint", and then press
"ENTER".
d. Type "exit", and press "ENTER" to close the Command Prompt.
5. Make a backup of the \Program Files\Microsoft SQL
Server\MSSQL$SharePoint\Data folder.
6. Restore only the configuration and content databases to \Program
Files\Microsoft SQL Server\MSSQL$SharePoint\Data. These files are:
a. STS_Config.mdb
b. STS_Config_log.mdf
c. STS_Servername_1.mdf
d. STS_Servername_1_log.ldf
Note: Do not restore any other default files such as master.mdf or model.mdf
7. ** If you have created any additional content databases, they must also
be restored to the \Program Files\Microsoft SQL
Server\MSSQL$SharePoint\Data folder.
8. Start MSSQL$SharePoint service.
a. Click "Start", and then click "Run".
b. In the "Open:" box, type "cmd", and then click "OK".
c. At the command prompt, type "net start msql$sharepoint", and then press
"ENTER".
d. Type "exit", and then press "ENTER" to quit Command Prompt.
9. If you try to access Companyweb (http://companyweb), its sub webs, or
any other top level SharePoint Web sites, you may receive the following
error message(s):
The virtual server that is referenced here is not in the configuration
database
- Or -
The page cannot be found
The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.
HTTP 400 - Bad Request
Internet Explorer
Remove SBS 2003 SharePoint Services from Companyweb
==================
Before you can extend the CompanyWeb with SBS 2003 SharePoint Services SBS
2003, you must first remove SharePoint Services from CompanyWeb.
1. Click "Start", point to "Programs", click "Administrative Tools", and
then click "SharePoint Central Administration". (http://localhost:8081)
2. On the "Central Administration" page, under "Virtual Server
Configuration", click "Configure virtual server settings".
3. On the "Virtual Server List" page, select the virtual server you want to
configure. In this case, select "companyweb".
4. On the "Virtual Server Settings" page, under "Virtual Server
Management", click "Remove Windows SharePoint Services from virtual server".
5. On the "Remove Windows SharePoint Services from Virtual Server" page,
and then click "Remove without deleting content databases".
6. Click "OK".
7. You will receive the following error message:
The virtual server that is referenced here is not in the config database.
NOTE: It''s normal, please proceed on the next steps in this article.
Extend the CompanyWeb Virtual Server with SBS 2003 SharePoint Services
==================
When you extend the CompanyWeb virtual server, a new site is created at the
root of the virtual server.
1. Click "Start", point to "All Programs", select "Administrative Tools",
and then click "SharePoint Central Administration". (http://localhost:8081)
2. On the "Central Administration" page, under "Virtual Server
Configuration", click "Extend or upgrade virtual server".
3. On the "Virtual Server List" page, click the name of the virtual server
to extend. In this case, click "companyweb".
4. On the "Extend Virtual Server" page, in the "Provisioning Options"
section, select "Extend and map to another virtual server".
5. In the "Server Mapping" section, select "companyweb".
6. In the "Application Pool" section, click "Use an existing application
pool", and select "DefaultAppPool (NT AUTHORITY\NETWORD SERVICE)".
7. Click "OK".
Configure the SBS 2003 SharePoint Services Accounts
==================
If you try to access CompanyWeb (http://companyweb), its sub webs, or any
other top level SharePoint Web sites using administratrative credentials,
you may receive the following error:
Cannot complete this action. Please try again
Note: The error is caused by the fact that the new Administrator account is
the Site Collection Owner and has a different SID that does not match the
one in the database.
You will have to log on with another Domain Administrator account to reset
ownership of the site collection. To do so:
1. Assign an E-mail address to the new administrator account with the
steps below:
a. Click "Start", click "Run" and in the "Open: "box type:
"http://companyweb", and then click "OK".
b. On the CompanyWeb home page, click "Site Settings".
On the "Site Settings" page, in the "Manage My Information section",
click "View information about site users".
c. On the "User Information" page, click "Administrator", and then click
"Edit User Information".
d. Specify administrator@<domain.local> as the E-mail Address, click to
check the "Site collection administrator" checkbox, click "Save" and then
click "Close".
2. Set the Administrator account as the new Site Collection Owner for the
CompanyWeb Web site.
To do so:
a. Click "Start", point to "All Programs", select "Administrative Tools",
and then click "SharePoint Central Administration" (http://localhost:8081).
b. On the "Central Administration" page, under "Security Configuration",
click "Manage site collection owners".
c. On the "Manage Site Collection Owners" page, in the Site URL section,
specify "http://companyweb" as the Web site URL, and then click "View".
3. In the "Site Collection Owner" section, set the the user name to
"domain\administrator".
a. Click "Start", click "Run", in the "Open:" box type
"http://companyweb", and then click "OK".
b. On the CompanyWeb home page, click "Site Settings".
c. On the "Site Settings" page, in the "Administration" section, click "Go
to Site Administration".
d. On the "Top-level Site Administration" page, in the "Site Collection
Administration" section, click "View site collection user information".
e. On the "Manage Site Collection Users" page, write down all the user
accounts. You will use this information to re-create the users accounts.
f. Select all accounts except the Administrator account (place a check
mark next to each account), click "Remove Selected Users", and then click
"OK" to confirm.
Make sure to remove the four template accounts listed below below:
- Administrator Tmpl
- Mobile User Tmpl
- Power User Tmpl
- User Tmpl).
Re-create the SBS 2003 SharePoint Services User Accounts
==================
1. Click "Start", click "Run" and in the "Open: "field, type
"http://companyweb", and then click "OK".
2. On the CompanyWeb home page, click "Site Settings".
3. On the "Site Settings" page, in the "Administration" section, click
"Manage Users".
4. On the "Manage Users" page, click "Add Users".
5. On the "Add User" page, in the"Step 1: Choose Users" section, specify
the following accounts:
- administrator@<domain.local>
- Administrator Tmpl@<domain.local>
- Power User Tmpl@<domain.local>
6. in the "Users" field. click the check box for "Administrator", and then
click "Next".
7. On the "Add User" page, in "Step 3: Confirm Users" section, verify that
the User Name and Display Name is correct.
8. In the "Step 4: Send E-mail" section, click to clear the"Send the
following e-mail to let these users know they?ve been added" checkbox.
Click "Finish" to return to the "Manage Users" page.
9. Click "Add Users" and specify "Mobile User Tmpl@<domain.local>; User
Tmpl@<domain.local>" in the "Users" field. Click the "Web Designer"
check box, and then click Next.
10. Verify the information in the "Step 3: Confirm Users" section.
11. In the "Step 4: Send E-mail" section, click to clear the "Send the
following E-mail to let the users know they have been added" check box, and
then click "Finish" to return to the "Manage Users" page.
12. Repeat Step 8 through Step 10to re-create the rest of the accounts, and
assign them to the correct Site Groups. Note: By default, Users and Mobile
Users belong to the Web Designer site group; Power Users and Administrators
belong to the Administrator sitegroup.
13. **Repeat for additional top-level web sites.
We have tested it in our lab and it works perfectly. I hope it helps!!
Additional information:
829114 How to remove and how to install the Windows Small Business Server
2003 SharePoint Services Companyweb Web site
http://support.microsoft.com/?id=829114
Have a nice day!
Best Regards,
Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
shannon
think they are relevant because I do not want to restore the default
databases. I do not want to overwrite the current company web. I just want
to create a duplicate companyweb on a restore site so I can restore a few
deleted files to the current company web. I have followed the instructions I
posted and getting an error. The restore database is there but it does not
look like the site was created. Even though the command prompt operation
said it completed successfully. Please let me know if I am missing
something. Thanks Shannon
Jenny wu [MSFT]
Thanks for you update.
I am sorry for the delayed response due to weekend. Please understand that
the newsgroups are staffed weekdays by Microsoft Support professionals to
answer your systems and applications questions. Your understanding is
greatly appreciated!
Please try to restore the site database using SQL Enterprise Manager to
test:
1. Open SQL Enterprise Manager.
2. Click the plus sign (+) next to Microsoft SQL Servers.
3. Click the plus sign (+) next to SQL Server Group.
4. Click the plus sign (+) next to the SharePoint instance.
5. Right-click the Database folder, select All Tasks, and click
Restore Database.
6. Type in or select a name for Restore as database. If you are
restoring to recover all data, you can use the original name, but if you
are restoring to get a single file or site, you may want to use a different
name.
7. From the Show backups of database list, select the database that
you backed up.
8. Select the Restore in the list box, and then click OK.
Then try to do the below 2nd step, how about the result?
If the issue persists, please help me collect some information as I
recommended below.
And then try to follow the below steps to restore those files again, how
about the result? If the issue persists, please help me collect some
information as I recommended.
===================
To restore SharePoint files:
From the server:
1. Click Start, click Command Prompt, and then type "%SystemDrive%\Program
files\Common files\Microsoft shared\Web server
extensions\60\Bin\Stsadm.exe" -o createsiteinnewdb -url
http://companyweb/sites/RestoredSite -ownerlogin DOMAIN\administrator
-owneremail admini...@DOMAIN.local -databasename STS_RESTORE, where
DOMAIN is your server domain and admini...@DOMAIN.local is your
administrator's e-mail address. Include the quotation marks as part of the
path. Press ENTER.
2. Type "%SystemDrive%\Program files\Common files\Microsoft shared\Web
server extensions\60\Bin\Stsadm.exe" -o restore -url
http://Companyweb/Sites/Restoredsite -filename target path -overwrite,
where target path is the location where you chose to save your SharePoint
backup. Include the quotation marks as part of the path. Press ENTER.
3. Open Internet Explorer. In the address bar, type
http://Companyweb/Sites/Restoredsite. The site that appears is the same as
your company Web site.
4. In the restored site, navigate to the missing file.
5. Right-click the file, select Save Target As, and then select a location
to which to save the file.
6. Repeat steps 4 and 5 for all missing files.
7. Open your company Web site, navigate to the location where the missing
files should be, and then on the SharePoint toolbar, click Upload Document.
*Note:You cannot upload multiple files at the same time using the remainder
of the steps in this procedure. If you have a large number of files to
restore to the same location, click Start, click Server Management, click
Internal Web Site, and then click Import Files.
8. Type the path or browse to the location where you saved the file, and
then on the SharePoint toolbar, click Save and Close.
9. To delete the restored subsite:
o Click Start, click Server Management, click Internal Web Site, and then
click Central Administration.
o Under Virtual Server Configuration, click Configure Virtual Server
Settings.
o Click companyweb.
o Under Virtual Server Management, click Delete site collection.
o Type http://Companyweb/Sites/Restoredsite, click OK, and then click
Delete.
10. To delete the content database:
o Under Virtual Server Management, click Manage content databases.
o Click STS_RESTORE.
o Under Remove Content Database, select remove content database, and then
click OK.
o Click Start, click Command Prompt, and then type osql -E -S
SERVERNAME\SharePoint -Q "drop database sts_restore", where SERVERNAME is
the name of the server running Windows Small Business Server 2003. You must
include the quotation marks. Press ENTER.
===================
Information needed:
===================
Could you help me collect some information to further troubleshooting the
issue?
1. Please give me the screenshot of the phenomena occurs.
>C:\Documents and Settings\Administrator>"c:\program files\common
>files\microsoft
>shared\web server extensions\60\bin\stsadm.exe" -o restore -url
>http://companyw
>eb/sites/restore2 -filename "d:\shareptbackup\restoreweb.bak" -overwrite
>Cannot complete this function.
2. Please give me the screenshot of the phenomena occurs.
>When I go to the restore site the message on the page is The Web site that
>is referenced here is not in the configuration database.
3. Please save me a text copy of error event log related the issue:
A. Open Event Viewer: Start -> All Programs -> Administrative Tools ->
Event Viewer.
B. Right-click on Application log and select "Save Log File As?".
4. Please give me the STSAdm.log file.
To access the temp folder of the currently logged on user, follow the steps
below:
A. Click Start, and then click Run.
B. Type %temp% and click Open.
5. Please help me collect the W3WP.log file.
You can find the file in: %windir%\temp\w3wp.log
===================
I appreciate you time and effort to perform test. I am looking forward to
you!
Have a nice day!
Best Regards,
Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>Thread-Topic: SharePoint Restore Error
>thread-index: AcWUTjLf7KIoYAnNQ62VVLToSLfGLA==
>X-WBNR-Posting-Host: 65.118.183.4
>From: "=?Utf-8?B?c2hhbm5vbg==?=" <sha...@discussions.microsoft.com>
>References: <DB7AA5A6-2347-4AD3...@microsoft.com>
<ruqw3YBl...@TK2MSFTNGXA01.phx.gbl>
>Subject: RE: SharePoint Restore Error
>Date: Fri, 29 Jul 2005 08:00:03 -0700
>Lines: 312
>Message-ID: <C3E99E9E-A012-496C...@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:139881
>X-Tomcat-NG: microsoft.public.windows.server.sbs
shannon
"BackupDiskFile::OpenMedia: Backup device 'D:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\BACKUP\STS_HERMES_1_00__d36fd566_b96b_4bd2_8bd6_6f1f144194a6_'
failed to open. Operating system error = 2(The system cannot find the file
specified.)."
It gives me a list of dates to choose from in the first backup to restore.
I get the error when I pick any of them. I noticed that the folder it is
looking in for these files is empty. How can that be if its seeing options
to restore? I did a search for
STS_HERMES_1_00__d36fd566_b96b_4bd2_8bd6_6f1f144194a6 with no luck. Where
else could these files be???
If I am SOL how can I prevent this in the future??? Something is obviously
out of whack.. Please Advice
Jenny wu [MSFT]
Thanks for you update.
For your now situation, the issue should be caused by incorrect backup set.
I suggest you use RESTORE VERIFYONLY to verify if the backup media is
correct. If the backup media is corrupted, you will not restore those files.
For avoiding the issue, I suggest that you always run RESTORE VERIFYONLY to
verify the backup when you completed backup task. In this way you can ensure
the back set is complete and you will not encounter this issue. Additionally
I suggest you set a resonable backup strategy to promote system security.
RESTORE VERIFYONLY
Verifies the backup but does not restore the backup. Checks to see that the
backup set is complete and that all volumes are readable. However, RESTORE
VERIFYONLY does not attempt to verify the structure of the data contained in
the backup volumes. If the backup is valid, Microsoft? SQL Server? 2000
returns the message: "The backup set is valid."
Syntax
RESTORE VERIFYONLY
FROM < backup_device > [ ,...n ]
[ WITH
[ FILE = file_number ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] LOADHISTORY ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] { NOREWIND | REWIND } ]
]
< backup_device > ::=
{
{ 'logical_backup_device_name' | @logical_backup_device_name_var }
| { DISK | TAPE } =
{ 'physical_backup_device_name' |
@physical_backup_device_name_var }
}
Please refer to the following link to get detail information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_2i9l.asp
If you have any further concern or question about the issue, please don't
hesitate to let me know. I am always happy be of assistance of you!
Have a nice day!
Best Regards,
Jenny Wu
Get Secure! - www.microsoft.com/security
======================================================
======================================================
"shannon" <sha...@discussions.microsoft.com> 写入邮件
news:E7AE05AE-9506-4DCD...@microsoft.com...