We use Avamar 7.1 for our SQL Server Backups. I have implemented Command Line Backups scheduled through our enterprise scheduler. At random times the backups seem to hang...

Hello. We didnt end up using that software. We currently use EMC's Avamar for our SQL server backups. We might re-visit recover point in the furture for DR sites.

Hello. I am experiencing a similar situation right now.

This is on a clustered SQL Server.

I had the SAN team physically expand a cluster disk/lun.

I had the Windows team expand it...

Thanks OPC.

From the link I found this:

For SQL Server 2005:

SQL Server Version Range

9.0.5000-9.0.5068

SQL Server Update

SQL Server 2005 Service Pack 4 GDR

(KB2716429)

SQL Server Version Range

9.0.5200-9.0.5323

SQL...

Hello. Are you using the (Reliability) backup option "Verify backup integrity" checkbox

during the backup session in SSIS?

Regards,

Mark G.

OPC, exactly what I was looking for.

Thank you very much!

Mark G.

The /PASSIVE option is also useful when a new node is added.

I have used that option to apply Service Packs to NEW passive nodes with out affecting the Active node...

I believe the Service pack will not update the client tools on the passive boxes.

So that is one reason to run the SP on the passive boxes, to update other...

Great article David. Thank you.

I thought that there were limits imposed on the various memory components based on on the total amount of memory given to SQL Server.

For example: Proc...

Thanks for the reply. Unfortunately AD is still 2003.

A good point though and a valid reason to upgrade.

Moderator,

I am sorry I didnt mean to post to the wrong forum.

Could you please movethis to te proper location at your earliest location if possible.

Thanks

Mark

It might be worth checking to see if there are any firewalls enabled on either server.

What operating system are your SQL 2005 servers running on?

Mark G.

Does that mean if you are already on SP3 then you are out of luck?

Thanks

Update:

Late yesterday the developer reported this occuring again so I investigated.

By this time I was convinced it had to be something they were doing.

I inserted a test record and this...

Great idea Magoo. I restored a backup from that morning of the issue but unfortunately could not reproduce the issue. My next backup occurred after I "fixed" the...