Re: MS-SQL TDP weirdness
2004-10-05 12:46:16
Neither my SQL guy nor I have any idea what you are talking about.
Can you please expand on what you are refering to when it comes to
"stripes" and the database backup ? How do I control this ?
I have never set any kind or parm that addressed striping (at least not to
my knowledge).
How would we get around this to be able to restore the database(s) ? We
are simply using the GUI and clicking on RESTORE !
Del Hoobler <hoobler AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/05/2004 11:10 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
Re: MS-SQL TDP weirdness
Zoltan,
How many stripes were used to back up the database?
How many stripes are you using for the restore?
Data Protection for SQL opens a separate TSM Server session
for each stripe.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 10/05/2004
10:44:27 AM:
> We had an MS-SQL server crash on us.
>
> While we are waiting on the hardware fix, we are trying to restore the
SQL
> server databases to another SQL server.
>
> So far, all attempts have failed.
>
> The server we are trying to restore to keeps trying to open up dozens of
> simultaneous sessions, exceeding the TSM server max (I raised the
> maxsessions from 40 to 60 and it tries to max out 60).
>
> All I keep getting is:
>
> 10/5/2004 10:35:24 AM ANR0403I Session 3269 ended for node
> ADMNT30.ADM.VCU.EDU (TDP MSSQLV2 NT).
> 10/5/2004 10:35:24 AM ANR0403I Session 3271 ended for node
> ADMNT30.ADM.VCU.EDU (TDP MSSQLV2 NT).
>
> <snippage>
>
> 10/5/2004 10:35:25 AM ANR0403I Session 3382 ended for node
> ADMNT30.ADM.VCU.EDU (TDP MSSQLV2 NT).
>
>
> 10/5/2004 10:35:24 AM ANR0429W Session 3387 for node ADMNT30.ADM.VCU.EDU
> (TDP MSSQLV2 NT) refused - maximum server sessions (60) exceeded.
>
> The TSM server is 5.1.8 on z/OS.
>
> The TSM client is 5.1.1.5 (on both the original and restoring server).
>
> The TDPSQL is the latest, 5.2.x, I think !
>
> We have done this kind of restores in the past, with no issues.
>
> The SQL guy even tried both SQL-2000 and SQL7 servers.
>
>
> Any clues ?
|
|
|