Re: [ADSM-L] TSM TDP SQL backup crashes after first database

We always use legacy.  I did try it as VSS but got an odd authentication
error?? Since we never use VSS I didn't know if that was important.  There
are no errors in the windows event logs, just the successful backup event.
I did go into the SQL management console and did a backup from there to
.BAK files with no issues.  I don't think these are always on or anything
like that.

On Thu, May 25, 2017 at 3:06 PM, Efim <aefim771 AT gmail DOT com> wrote:

> The version is correct.
> Do you use legacy or VSS backup? If VSS: did you run the VSS diagnostics
> on all the disks where the databases are located (configuration wizard) ?
> What are the errors in the DP logs and windows events at the time of
> copying? Are these AlwaysOn databases?
> Efim
>
> > 25 мая 2017 г., в 21:45, Tom Alverson <tom.alverson AT GMAIL DOT COM>
> написал(а):
> >
> > The version number for sqlserver.exe is 10.50.6220.0 which indicates
> 2008R2
> > SP3.  My reading of the compatibility lists led me to create this table
> > (let me know if this is wrong) and 7.1.6.x should even go back as far as
> > SQL server 2008 (non-R2):
> >
> > TSM TDP Version SQL Version Support
> > 6.3.0 2005 2008 2008R2
> > 6.3.1 2005 2008 2008R2 2012
> > 6.4.0 2008 2008R2 2012
> > 6.4.1 2008 2008R2 2012
> > 7.1.0 2008 2008R2 2012
> > 7.1.1 2008 2008R2 2012 2014
> > 7.1.2 2008 2008R2 2012 2014
> > 7.1.3 2008 2008R2 2012 2014
> > 7.1.4 2008 2008R2 2012 2014
> > 7.1.6 2008 2008R2 2012 2014 2016
> >
> > On Thu, May 25, 2017 at 1:53 PM, Efim <aefim771 AT gmail DOT com> wrote:
> >
> >> Hi,
> >> Which service pack is installed on SQL?
> >> DP supports only 2008R2 SP2 and later.
> >> Efim
> >>
> >>
> >>> 25 мая 2017 г., в 20:35, Tom Alverson <tom.alverson AT GMAIL DOT COM>
> >> написал(а):
> >>>
> >>> I have an SQL 2008R2 database server with 32 databases on it.  My
> backup
> >>> job crashes like this after the first database is successfully backed
> up:
> >>>
> >>> Beginning full backup for database Application_Registry_Service_DB, 1
> >> of 32.
> >>> Full: 0   Read: 3232256  Written: 3232256  Rate: 2,452.60 Kb/Sec
> >>> Full: 0   Read: 3234560  Written: 3234560  Rate: 2,061.85 Kb/Sec
> >>> Database Object Name: 20170525132822\0000040C
> >>> Backup of Application_Registry_Service_DB completed successfully.
> >>>
> >>> It even exits with errorlevel 0, but does not continue on to the next
> >>> database, and never finishes up the summary log.
> >>>
> >>> If I exclude that database the same thing happens on the second
> database.
> >>> If I exclude the first two, it crashes on the third, etc etc.   If I
> try
> >>> these in the GUI, the GUI crashes at the end of the first backup.  I
> have
> >>> already updated to the latest clients I had around:
> >>> BACLIENT 7.1.6.4
> >>> TDP SQL    7.1.6.2
> >>>
> >>> Does anyone have any insight on what might be happening? The windows
> >> event
> >>> log just shows a successful backup of the first database and no errors.
> >>
>