"ADSM: Dist Stor Manager" wrote on 06/16/2010
02:38:51 PM:
> [image removed]
>
> DP for DB's: SQL Restore question
>
> Rick Adamson
>
> to:
>
> ADSM-L
>
> 06/16/2010 02:39 PM
>
> Sent by:
>
> "ADSM: D
I think you must use options /partial /recovery=yes (available only in cmd)
Efim
I have been asked many times to restore databases from TSM to flat
files, and not attach them to the SQL Server. I have tried to use the
"Restore Groups/Files option" but when I open the SQL Mngmt Studio, it
shows the database with a status of "restoring". Have also tried not
using the recovery opt
t Stor Manager [mailto:[EMAIL PROTECTED] On
> Behalf Of David Longo
> Sent: Thursday, 28 June 2007 11:49 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] TDP for SQL restore question
>
> Maybe DB was smaller when you restored to D drive, or D is faster disk
than E.
>
> For thi
Maybe DB was smaller when you restored to D drive, or D is faster disk than E.
For this size you need bigger timeout, I have COMMTIMEOUT on
TSM server set to 15,000 seconds (250 minutes)
What is happening is that SQL (not TSM) is building the DB
for the data to be restored to. If it was only sa
I am currently trying to restore a database from our production server
onto the E drive of a test server.
I have previously been able to restore a database from our production
server onto the D drive of the test server.
The database is 40 Gb in size.
When I have tried this previously the session
0)403-2281
John Naylor
cc:
Sent by: "ADSM: Dist Stor Subject: Re: SQL restore
question
Manager"
<[EMAIL PROTECTED]>
11/08/2000 10:44 AM
er" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: Re: SQL restore question
Larry,
We are talking about the restore of the flat file from the TSM server to
the SQL server.
- Brian
Brian L. Nick
Systems Technician - Storage Solutions
Phoenix Hom
nager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: SQL restore question
Hello everyone,
I was just contacted by one of our DBA's and I have a questions about SQL
restore. We are running TSM 3.
Lawrence Clark
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
ATE.NY.US> cc:
Sent by: "ADSM: Dist Subject: Re: SQL restore
question
S
The restore of the 'flat' file to the server is TSM, the restore of the flat file to
MS-SQL is MS-SQL. Which is it that is slow?
>>> [EMAIL PROTECTED] 11/08/00 08:56AM >>>
Hello everyone,
I was just contacted by one of our DBA's and I have a questions about SQL
restore. We are running TSM 3.7.
Hello everyone,
I was just contacted by one of our DBA's and I have a questions about SQL
restore. We are running TSM 3.7.3 on OS/390 2.9 and TSM client version
3.7.2. Please note that we are not using TDP for SQL. As explained to me by
our DBA there is a dump of the SQL data base taken every ni
12 matches
Mail list logo
