Prev: Event Viewer Error 3078
Next: mssdmn.exe multiple instances
From: "eforce" <col@newsgroup on 17 Jan 2006 02:24
Hi
I have installed SPS 2003 on SQL 2005 on 2 separate machines (one having
SPS 2003 SP2 and the other with SQL 2005 and running as a domain controller)

Currently we are trying out the backup and restore procedure.

The restore process FAILED with this error msg in event log
"SQL Server restore failed. Error: The operation failed on server
ABCSPSDC." - on the sharepoint server
"Login failed for user 'SPSDC\spsadmin'." - on the SQL 2005 server

Together there are these entry in the log file:

Here is the log file
00012E8C CRI 00000000 00000E5C Connecting to SQL Server ABCSPSDC ...<BR>
00012ED2 CRI 00000000 00000E5C Connected to SQL Server ABCSPSDC<BR>
00012ED2 CRI 00000000 00000E5C Connected To Server<BR>
00012ED2 CRI 00000000 00000E5C Entering RestoreDB for database
ABCPorta1_SITE ...<BR>
00012ED2 CRI 00000000 00000E5C Entered Critical Section in RestoreDB for
database ABCPorta1_SITE ...<BR>
00012ED2 CRI 00000000 00000E5C Left Critical Section in RestoreDB for
database ABCPorta1_SITE ...<BR>
00012FCC UNK 00000000 000007F8 Overall % Completed: 0%<BR>
00013008 CRI 80045510 00000E5C GetDatabaseByName Failed. Trying to obtain
path from master database.<BR>
0001313F CRI 00000000 00000E5C Command Text sent to SQL is: RESTORE DATABASE
[ABCPorta1_SITE] FROM DISK =
N'\\ABCsps\backup\bk5555-ABCSPSDC-ABCPorta1_SITE.SPB' WITH FILE = 1,
NOUNLOAD , STATS = 5, RECOVERY , REPLACE , MOVE N'ABCPorta1_SITE' TO
N'C:\Program Files\Microsoft SQL Server\MSSQL\data\ABCPorta1_SITE_Data.MDF',
MOVE N'ABCPorta1_SITE_log' TO N'C:\Program Files\Microsoft SQL
Server\MSSQL\data\ABCPorta1_SITE_Log.LDF', MOVE N'sysft_ix_ABCPorta1_SITE'
TO N'C:\Program Files\Microsoft SQL
Server\MSSQL\data\ABCPorta1_SITE_Data.MDF'<BR>
0001313F CRI 00000000 00000E5C Database ABCPorta1_SITE does not exist,
proceeding to restore it.<BR>
0001313F CRI 00000000 00000E5C Restoring database ABCPorta1_SITE ...<BR>
000131A3 CRI 80040C68 00000E5C Failed to restore the database.<BR>
000131A3 UNK 00000000 00000E5C No error information available<BR>
000131A3 UNK 00000000 00000E5C No error information available<BR>
000131A3 UNK 00000000 00000E5C Exception in BackupSQL: Source=SQLBkMgd,
Message=The operation failed on server ABCSPSDC. For more information, see
the Microsoft Windows Event Log on that server.<BR>
000131A3 UNK 00000000 00000E5C BackupSQL Thread setting its status to
completed and exiting<BR>
0001371D UNK 00000000 00000F78 Portal site http://portal.ABC.edu.sg/ does
not exist. INDEX cannot be restored<BR>
00013E3B UNK 00000000 000006C4 Released search lock on server ABCSPS<BR>
000143C9 UNK 00000000 000007F8 Overall % Completed: 0%<BR>
00014550 UNK 00000000 000007F8 Overall % Completed: 0%<BR>
00014550 UNK 00000000 000007F8 ProgressThread set completed status and is
now exiting<BR>
00014618 UNK 00000000 000006C4 Overall % Completed: 0%<BR>
00014618 UNK 00000000 000006C4 Started Refreshing Collections<BR>
00014622 UNK 00000000 000006C4 Finished Refreshing Collections<BR>


I am suspecting that it is due to restore database statement. Hence I tried
running the statement manually.

RESTORE DATABASE [ABCPorta1_SITE] FROM DISK =
N'\\ABCsps\backup\bk5555-ABCSPSDC-ABCPorta1_SITE.SPB' WITH FILE = 1,
NOUNLOAD , STATS = 5, RECOVERY , REPLACE , MOVE N'ABCPorta1_SITE' TO
N'C:\Program Files\Microsoft SQL Server\MSSQL\data\ABCPorta1_SITE_Data.MDF',
MOVE N'ABCPorta1_SITE_log' TO N'C:\Program Files\Microsoft SQL
Server\MSSQL\data\ABCPorta1_SITE_Log.LDF', MOVE N'sysft_ix_ABCPorta1_SITE'
TO N'C:\Program Files\Microsoft SQL
Server\MSSQL\data\ABCPorta1_SITE_Data.MDF'

Below is the error msg:

Msg 3176, Level 16, State 1, Line 1
File 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\ABCPorta1_SITE_Data.MDF' is claimed by
'sysft_ix_ABCPorta1_SITE'(65537) and 'ABCPorta1_SITE'(1). The WITH MOVE
clause can be used to relocate one or more files.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I am wondering why does the restore statement try to move both the
sysft_ix_ABCPorta1_SITE and ABCPorta1_SITE tried to move to the same file
ABCPorta1_SITE_Data.MDF ?

So anyone tested the backup and restore tool from SPS2003 on SQL 2005?

Please advise

Thanks.


From: eforce on 18 Jan 2006 20:37
Anyone deploying SPS 2003 with sql 2005?

Is it advisable?

Any known problems?

Thanks.


From: Hollis D. Paul on 18 Jan 2006 06:58
In article <uNZEijJHGHA.2440(a)TK2MSFTNGP14.phx.gbl>, Eforce wrote:
> Anyone deploying SPS 2003 with sql 2005?
>
> Is it advisable?
>
> Any known problems?
>
It is supported with SPS 2003 SP2 and WSS SP2. Some have reported that
they have had no problems.

Hollis D. Paul [MVP - Outlook]
Mukilteo, WA USA



 | 
Pages: 1
Prev: Event Viewer Error 3078
Next: mssdmn.exe multiple instances