SPS 2003 and SQL 2005 database restore problems

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am trying to do a test run of backing up and restoring our Portal
websites and portal itself but am having very bad luck. We are
running SPS 2003 and SQL Server 2005 and yes, I have downloaded and
installed the post-service patch hotfix from microsoft but still
things are not working. Now, I am quite new to all of this and i'm
just an intern trying to do a test backup/restore so that we know what
to do if in fact the system does one day crash.

@ echo=Off

cd\

spsbackup.exe /all /file \\filepath/overwrite

we use SPS backup/restore to backup and the preceding script to make
it backup everynight.

The backup process works just fine with no problems but it is the
restore that will not work. After running SPSrestore these are the
errors that came up within the windows application event viewer...


BackupDiskFile::OpenMedia: Backup device '\\Restoretest\Portal backup
\filename.SPB' failed to open. Operating system error 1265(The system
detected a possible attempt to compromise security. Please ensure that
you can contact the server that authenticated you.).

SQL Server restore failed. Error: The operation failed on server
RESTOREPORTAL. For more information, see the Microsoft Windows Event
Log on that server. , Server: RESTOREPORTAL, Database: WSS-Part,
Backup location: \\Restoretest\Portal backup\filename.SPB

BackupDiskFile::OpenMedia: Backup device '\\Restoretest\Portal backup
\filename.SPB' failed to open. Operating system error 1265(The system
detected a possible attempt to compromise security. Please ensure that
you can contact the server that authenticated you.).

SQL Server restore failed. Error: The operation failed on server
RESTOREPORTAL. For more information, see the Microsoft Windows Event
Log on that server. , Server: RESTOREPORTAL, Database: WSS_Sal, Backup
location: \\Restoretest\Portal backup\filename.SPB

And when i went to "C:\Program Files\SharePoint Portal Server\Logs"
this was the log file contents....


GetDatabaseByName Failed. Trying to obtain path from master
database.<BR>
Command Text sent to SQL is: RESTORE DATABASE ["site"] FROM DISK =
N'\\Restoretest\Portal backup\filename.SPB' WITH FILE = 1,
NOUNLOAD , STATS = 5, RECOVERY , REPLACE
<BR>
Database "site" does not exist, proceeding to restore
it.<BR>
Restoring database WSS-
Partner ...<BR>
Failed to restore the
database.<BR>
No error information
available<BR>
No error information
available<BR>
Exception in BackupSQL: Source=SQLBkMgd, Message=The operation failed
on server RESTOREPORTAL. For more information, see the Microsoft
Windows Event Log on that
server.<BR>
BackupSQL Thread setting its status to completed and
exiting<BR>
BackupSQL now in progress: Restore=True, Server=RESTOREPORTAL,
Database="site2", Path=\\Restoretest\Portal backup
\filename2.SPB<BR>
SQL Restore called with Server=RESTOREPORTAL, Database="site2",
BackupPath=[\\Restoretest\Portal backup\filename2.SPB], Percent=5

<BR>
Connecting to SQL Server
RESTOREPORTAL ...<BR>
Connected to SQL Server
RESTOREPORTAL<BR>
Connected To
Server<BR>
Entering RestoreDB for database
"site2"...<BR>
Entered Critical Section in RestoreDB for database
"site2"...<BR>
Left Critical Section in RestoreDB for database
"site2"...<BR>
GetDatabaseByName Failed. Trying to obtain path from master
database.<BR>
Command Text sent to SQL is: RESTORE DATABASE ["site2"] FROM DISK =
N'\\Restoretest\Portal backup\filename2.SPB' WITH FILE = 1,
NOUNLOAD , STATS = 5, RECOVERY , REPLACE
<BR>
Database "site2" does not exist, proceeding to restore
it.<BR>
Restoring database
"site2"...<BR>
Failed to restore the
database.<BR>
No error information
available<BR>
No error information
available<BR>
Exception in BackupSQL: Source=SQLBkMgd, Message=The operation failed
on server RESTOREPORTAL. For more information, see the Microsoft
Windows Event Log on that
server.<BR>
BackupSQL Thread setting its status to completed and
exiting<BR>
Released search lock on server
RESTOREPORTAL<BR>
ProgressThread set completed status and is now
exiting<BR>
Started Refreshing
Collections<BR>
Finished Refreshing
Collections<BR>
Started Refreshing
Collections<BR>
Finished Refreshing
Collections<BR>
Started Refreshing
Collections<BR>
Finished Refreshing Collections<BR>

I think there are some problems involving SQL and the rights I have to
read and write files and which ones i have access to. I am logged on
to virtual server 2005 r2 as the administrator. So basically, I am
pretty lost right now and could use any tips at all.

Thanks,
Dave

.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • Re: Copying a database between servers
    ... In 2000 you can backup to an UNC path ... or a local drive and the same goes for the restore. ... backup the database and then restore it on the new server. ... >>> one SQL Server 7.0 database with 'select' access to another SQL ...
    (microsoft.public.sqlserver.tools)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: Adventures in Server restore
    ... >> I thought I'd pass on my experience in bringing back an exchange server ... >> restore exercises, a real restore turned out to be far from easy. ... I'm not sure what happened (but a online backup was going ... >> persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)