Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Backup Restore Problem

  Asked By: Susana    Date: Nov 21    Category: Sharepoint    Views: 714

Recently I have upgrade Service Pack 2 of WSS and SPS on my Share Point
Portal Server 2003 / WSS 2.0.

After upgrade it is working fine but I am trying to restore backup
through "SharePoint Portal Server Data Backup and Restore"

An error message displaying "restore unsuccess- check log file" as it
close to restore process,

Please let me its solution.



6 Answers Found

Answer #1    Answered By: Constance Guerrero     Answered On: Nov 21

Was the backup  from before you did the upgrade  to sp2? If so, I just
recently learned that the restore  machine must be at the same level as
when the backup was taken.

Answer #2    Answered By: Chandrabhan Konwar     Answered On: Nov 21

It is after upgrade  SP2,

Error message display on screen, same error message, If I try to restore
on an other machine with different name after update sp2 on this

Answer #3    Answered By: Tina Owens     Answered On: Nov 21

Check your SQL server  and ensure that your Log file is not growing and
filling up all available space on your database server.

The error message in SPSBACKUP should indicate whether or not you should
look at the event log on the SQL Server if in fact this might be what
the issue is.

Answer #4    Answered By: Tiana Whitaker     Answered On: Nov 21

For my own clarification, because I will be going down this same road
here really soon.

Are you suggesting that before the restore  process to truncate
your SQL databases? I shamefully admit that mine currently are rather

Answer #5    Answered By: Alice Chandler     Answered On: Nov 21

For most installations, the transaction logs can be truncated immediately after
a full backup. Unless you plan on doing point in time recoveries you don't need
them. If you don't, then first, set your database recovery method to "Simple."
(Sorry if that isn't the exact setting, I'm working off of memory). Then go
into Enterprise Manager (SQL 2000) or SQL Management Studio (SQL 2005), go to
the properties of the database and shrink files. Shrink the transaction logs.
When your recovery mode is set to simple SQL will truncate them itself after you
do a full backup  of a database, so you should be good going forward.

Answer #6    Answered By: Lynette Sawyer     Answered On: Nov 21

No, I'm not suggesting that you truncate your databases, but your log
files will grow as the restore  is proceeding.

I don't have the steps necessary for what you want to do off the top of
my head, but suggest looking at the "Disaster Recovery" documentation on

Perhaps setting a limit to the size of your logs, so that they are
flushed to the database upon reaching that limit.

Didn't find what you were looking for? Find more on Backup Restore Problem Or get search suggestion and latest updates.