Unsolved

This post is more than 5 years old

12 Posts

1581

June 13th, 2012 03:00

EMC Networker 7.6 SP2 - several problems in backuping SQL & Exchange

Hi Networkers .

I have several problems regarding backup SQL and Echange Servers.

Problem 1 - Cannot do an incremental backup of SQL.

My schedule Group for my SQL is the following:

Full backup once a week, incremental backup in every other days, but every day backup type is "Full".

When Schedule Group starts which should do incremental backup, in "Monitoring" tap I get every time when Group starts the following message:

"No full backups of this save sets were found in the media database, performing a full backup"

I have to add, that recovery mode for database which is backuping is set to ""FULL"

version of SQL 2000 with SP4.

Problem 2. - Cannot do a scheduled backup of Exchange 2003

Scheduled group is finished with the following error (screen "exchange.png" in attachment)

Problem 3. - Cannot do a scheduled backup of SQL which has a two instances.

My SQL Server has two instances, and when I try to backup a few databases from only one instance I get the following  (screen sql_instances.png attachment) and the backup is failed.

Any help ?

2 Attachments

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

June 13th, 2012 04:00

1) indicates your data is saved under wrong index.  Usually this is the case where cluster or DNS is not configured correctly. Some users are able to reproduce this by messing up with -c and -a options in a way it was not designed to be done.

2) You do not show what is the error message, but rather header log dump from group details.  You should check module logs and take it from there.

3) I do not see where you have listed few databases from same instance.  I'm doing that using NMSQL 5.2.2 (and 5.2.1 before) and it works ok, but I have a feeling that your definition of saveset is not correct one.  Perhaps you wish to share more details.

12 Posts

June 13th, 2012 05:00

1) indicates your data is saved under wrong index.  Usually this is the case where cluster or DNS is not configured correctly. Some users are able to reproduce this by messing up with -c and -a options in a way it was not designed to be done.

I don' have cluste and DNS is working correctly. So What Should I do to resolve this problem ?

2) You do not show what is the error message, but rather header log dump from group details.  You should check module logs and take it from there.

.

Tomorrow I will attach module logs here so You will look at it.

3) I do not see where you have listed few databases from same instance.  I'm doing that using NMSQL 5.2.2 (and 5.2.1 before) and it works ok, but I have a feeling that your definition of saveset is not correct one.  Perhaps you wish to share more details.

I'm also using NMSQL 5.2.2. Below is a screen from configuration wizzard of this client resource.

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

June 14th, 2012 03:00

Yes, 99% of people claim their DNS works nice... if it does, then you have configuration issue   So let's take step by step:

1) Go to client and inspect module log.. do NOT copy and paste here - YOU should read it and understand it. Check the log and what does it say there. With that in mind, you claim that you have full once a week and incremental every other day, but you get full each day. Are you aware that incremental backup is transaction log backup? I mean, what you are trying to do is full database backup once a week and then once per day transaction log backup which is a bit odd. Usually you protect your database with full once a day and transaction logs depending what your SLA is (I run it every one hour). You should also have separate groups for database and transaction log backups. And, be aware that if SQL records another program doing backup (like SQL dump for example), next time you run NetWorker SQL backup, SQL will alter that backup (eg. transaction log backup) to full (database) backup.  This is how MS SQL works to preserve consistancy of backup cycle. So, you might even have someone else doing backup between your full and incremental level as it is right now. If so, you will see that in both event log and module log.

2) I would suggest to use your official support line.  They are paid for that.

3) What you should really show us is what is configured in client resource and how exactly this is configured on client side (from SQL point of view).

I think it is fair to say you do not have much experience so things may be a bit rough in start.  What I would suggest is that you talk to your official support line - getting help for something you do not understand over web is a risky business.

12 Posts

June 14th, 2012 03:00

Hi,

I will use official support line to resolve my problems

Thank You very much for your help and important information/suggestions.

Greetings,

damiano_

0 events found

No Events found!

Top