SPS 2003 Restore with SQL 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.


.

Relevant Pages

  • Re: Restoring SharePoint Portal 2003 & SQL
    ... running with two WFE servers, one index and one SQL Server. ... re-assign the server roles, restore the shared services portals, then ... please use the backup and restore tool that ships with SPS03. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Migration ?
    ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS Sharepoint (CompanyWeb) DR restore process
    ... If your site does not contain any custom web parts (which have to be installed on the new server) the move should be straight forward. ... Copy the backup file from the old server to the new. ... the process to perform a backup and restore of the sharepoint component of SBS. ... However, most of the documentation I've found refers to scenario's involving MSDE ONLY, and specifically mention the process is not identical for scenario's where full SQL is installed. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot use file for clustered server
    ... My restore appears to be running nicely right now ... > Double click SQL Server resource and add G: ... >> on which the cluster resource of the server has a dependency can be used. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQLDUMPER library error message (PLEASE HELP)
    ... I ran services.msc and disabelled SQL Server VSS ... >>> Accounting 2007, a new program that I do not even know when or why I ... >> an MS Office 2007 trial - or do a System Restore. ... you'll see an entry made just ...
    (microsoft.public.windowsxp.general)