Data Backup and Recovery

SMMOSS 5.0 backup running 70 minutes

__schaefers_12762
3,823 Views

Hi all,

Our SP farm consists of 1 DB server, 2 WFEs and 1 application server for various SP services. This is a new installation with just a few test pages.

Has anyone seen SMMOSS backup runtimes of 70 minutes? Is this normal? The job status hangs at 3% for about 50 minutes w/o any noticeable activity on any of the involved servers.

* Backup Result Report *

Plan Name: Daily Full Farm Backup
Plan ID: PLAN20100416091213
Backup Level: Item Version Level
Backup Type: Full Backup
Job ID: FB20100429233004
Agent Host: SPAPP01
Media Server: SMMOSS01
Agent Version: 5.0.0.0
Manager Version: 5.0.0.0
Username: admin
Start Time: 2010-04-29 23:30:04
End Time: 2010-04-30 00:40:53
Statistical Result: 21642 MB data, 7(0) site collections, 24(0) sites, 233(0) lists, 1201(0) items.

Thanks & Regards

Bernd

6 REPLIES 6

sourav
3,823 Views

Hi,

This is definitely not normal. It should not take more than 20-30

minutes for the backup job to complete. I would recommend you to check

the time it takes to complete the backup for the content database only

i.e. with no granularity setting. This will help in isolating the issue

to SMMOSS or SMSQL.

Regards,

Sourav.

abuchmann
3,823 Views

We've got the same problem with SMOSS 2.0.2.0...

Plan Name: Tägliche_Sicherung

Plan ID: PLAN20090625073605

Backup Level: Item Version Level

Backup Type: Full Backup

Job ID: FB20100501220008

Agent Host: <smmossagent>

Media Service: <smmossmgmtserver>

Client Version: 2.0.2.0

Server Version: 2.0.2.0

User Name: admin

Start Time: 2010-05-01 22:00:08

Finish Time: 2010-05-02 01:45:37

Statistical result:726514 MB data, 1315(0) site collections, 43862(0) sites, 616320(0) lists, 2282374(0) items.

But as sourav said, it could be a smsql issue. A closer look into the backup result (File 16-04-2010_22.37.29_<smmossmgmtserver>_clone-backup.txt in the SMSQL and SnapDrive output.zip) showed us the problem:

[22:37:29.9305480]: Initializing [clone-backup][System.String]
[22:37:29.9305480]: Backup : [sqlsnap__<smmossmgmtserver>_04-16-2010_22.03.28__daily][System.String]
[22:37:29.9305480]: Connecting to server: [<smmossmgmtserver>][System.String]
[22:37:29.9930500]: Connecting to server: [<smmossmgmtserver>][successful][System.String]
[22:37:29.9930500]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[22:39:18.4340200]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[22:41:13.1720665]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[22:43:06.2225590]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[22:44:56.8510990]: Retrieving backup list from SnapManager server. Please wait...[System.String]

.........

[00:28:48.6598855]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:30:29.8506235]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:32:06.6662215]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:33:42.0755245]: Validating Verification Server: [ <smmossmgmtserver> ][System.String]
[00:33:42.0911500]: Restore Source SQL Server Instance: <smmossmgmtserver>[System.String]
[00:33:42.0911500]: Restore Destination SQL Server Instance: <smmossmgmtserver>[System.String]

So it's a SMSQL-problem (still not solved...)

Kind regards,

Adrian

__schaefers_12762
3,823 Views

Hi Sourav,

The SMSQL backup looks okay, and finishes within 10 minutes. Before that the job just seems to hang at 3% for about 50 min. I can't find any activity within these 50 minutes (NetApp case #2001423896).

Thanks & Regards

Bernd

sourav
3,823 Views

Hi Bernd,

It looks to me that we may be facing issues in the backup indexing phase

which explains why the backup job hangs at 3% for a long while.

I see that you've already opened an NGS case. Hopefully you'll receive a

resolution soon.

Regards,

Sourav.

schaefers
3,823 Views

No resolution so far. I had to close the case today because we've moved on to Sharepoint 2010. Waiting for the next SMMOSS version supporting 2010...

Thanks,

Bernd

__schaefers_12762
3,823 Views

Thanks Adrian,

That log looks okay at our site:

00:32:25.7176841]: Initializing [clone-backup][System.String]
[00:32:25.7245203]: Backup : [sqlsnap__spdb01_04-30-2010_00.31.58__daily][System.String]
[00:32:25.7381927]: Connecting to server: [spdb01][System.String]
[00:32:26.2762993]: Connecting to server: [spdb01][successful][System.String]
[00:32:26.3710295]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:32:27.4726343]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:32:28.2587973]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:32:29.0322645]: Retrieving backup list from SnapManager server. Please wait...[System.String]
[00:32:29.8975321]: Validating Verification Server: [ SPDB01 ][System.String]
[00:32:29.9561281]: Restore Source SQL Server Instance: .....[System.String]
[00:32:29.9561281]: Restore Destination SQL Server Instance: .....[System.String]
[00:32:29.9561281]: Authentication Mode: Windows[System.String]
[00:32:29.9561281]: The input parameters are being validated.[System.String]
[00:32:29.9561281]: List of Databases:  [WSS_Content_.....] [WSS_Content_crhit] [WSS_Content_SSP] [WSS_Content_MySites]
Backup Name: sqlsnap__spdb01_04-30-2010_00.31.58__daily
This is a restore with integrity verification job.
[System.Collections.Generic.List`1[System.String]]
[00:32:29.9561281]: The input parameters validation successful.
[...]
[System.String]
[00:34:10.5937815]: The restore-backup cmdlet has completed processing successfully.[System.String]
[00:34:10.5957347]: Completed.
Regards
Bernd
Public