Re: backup exec + sharepoint 2007 database "cannot be opened it is in the middle of a restore"
- From: "Steve" <newsgroup@xxxxxxxxxx>
- Date: Wed, 16 Jan 2008 07:37:54 -0800
This newsgroup is for SBS 2003 so I think asking elsewhere will bring you a
greater response.
<phil.spencer@xxxxxxxxx> wrote in message
news:7de3f2b6-323b-4059-9877-4d642107a95b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,
I have sharepoint 2007 running on server 2003 + remote agent.
I also have a backup server running symantec backup exec 11d (with AFO
+ SQL + sharepoint agents) on server 2003
I've done a restore of the entire system on sharepoint and restarted.
Now when I do the daily backups on the sharepoint server I am getting
this error on backup exec:
---------------
Completed status: Failed
Final error: 0xe0008443 - One or more SQL Database consistency checks
have failed.
Final error category: Resource Errors
For additional information regarding this error refer to link
V-79-57344-33859
----------------
Backup- \\sabertooth.xxx.com\C: Win2K3An unknown or unexpected
database error occurred while attempting a DBCC.
Database 'SharedServices1_Search_DB_3a49eaa0-ef37-4264-
adb7-2f43ee2ae713' cannot be opened. It is in the middle of a restore.
An unknown or unexpected database error occurred while attempting a
DBCC.
Database 'WSS_Search_SABERTOOTH' cannot be opened. It is in the middle
of a restore.
--------------
I've installed EMS SQL query on sabertooth (our sharepoint server) to
tried and connect to the lcoal SQL database and run a query to tell it
that it isn't loading.
Problem is I cannot connect to the database with either windows
authentication or SQL server authentication, with event log getting
these errors:
Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local
machine>]
Any ideas how to connect to it?
If I am able to connect, do I run something like this?
"restore database dbname with recovery"
-------------Separate note:
I am also getting these errors in event viewer:
Event Type: Failure Audit
Event Source: MSSQL$OFFICESERVERS
Event Category: (4)
Event ID: 18456
Date: 15/01/2008
Time: 19:12:52
User: NT AUTHORITY\NETWORK SERVICE
Computer: SABERTOOTH
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named
pipe>]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 19 00 00 00 53 00 41 00 ....S.A.
0010: 42 00 45 00 52 00 54 00 B.E.R.T.
0018: 4f 00 4f 00 54 00 48 00 O.O.T.H.
0020: 5c 00 4f 00 46 00 46 00 \.O.F.F.
0028: 49 00 43 00 45 00 53 00 I.C.E.S.
0030: 45 00 52 00 56 00 45 00 E.R.V.E.
0038: 52 00 53 00 00 00 07 00 R.S.....
0040: 00 00 6d 00 61 00 73 00 ..m.a.s.
0048: 74 00 65 00 72 00 00 00 t.e.r...
.
- References:
- Prev by Date: Re: Users Shared Folders
- Next by Date: applying color to files and folders
- Previous by thread: backup exec + sharepoint 2007 database "cannot be opened it is in the middle of a restore"
- Next by thread: Re: Cannot connect Vista Fax and Scan to SBS 2003
- Index(es):
Relevant Pages
|
