I got one for both my posts yesterday. Tom Kauffman NIBCO INC.
> -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of Prather, Wanda > Sent: Friday, August 27, 2004 8:48 AM > To: [EMAIL PROTECTED] > Subject: Re: Rejected posting to [EMAIL PROTECTED] > > I've been getting these "rejected posting/identical text" messages > also. > Is this happening to everyone? > > W > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of > Moses Show > Sent: Friday, August 27, 2004 5:30 AM > To: [EMAIL PROTECTED] > Subject: Fw: Rejected posting to [EMAIL PROTECTED] > > > Your message is being returned to you unprocessed because it > appears to > have > already been distributed to the ADSM-L list. That is, a message with > identical > text (but possibly with different mail headers) has been posted to > the > list > recently, either by you or by someone else. If you have a good reason > to > resend > this message to the list (for instance because you have been > notified > of a > hardware failure with loss of data), please alter the text of the > message in > some way and resend it to the list. Note that altering the > "Subject:" > line or > adding blank lines at the top or bottom of the message is not > sufficient; you > should instead add a sentence or two at the top explaining why > you > are > resending the message, so that the other subscribers understand why > they > are > getting two copies of the same message. > > ----- Message from "Moses Show" <[EMAIL PROTECTED]> on Thu, 26 Aug > 2004 17:25:25 +0100 ----- > To: > [EMAIL PROTECTED] > Subject: > SQL database restore question > Hi people, > Have been trying to restore a database to a different location > on > a different server but am having problems. Was wondering if anyone can > shed any light as to where I am going wrong. > > First I queried the TSM server for the fileinfo of the database I want > to > restore from the new intended location as follows: > > C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc query TSM DWHPROD full > /fileinfo /fro > msqlserver=GBSTPF54 /tsmnode=GBSTPF54_SQL /tsmpassword=ntbackup > /mountwait=yes > > IBM Tivoli Storage Manager for Databases: > Data Protection for Microsoft SQL Server > Version 5, Release 2, Level 1.0 > (C) Copyright IBM Corporation 1997, 2003. All rights reserved. > > Restoring metadata ... > > > Waiting for TSM > server.......................................................... > ..........................................Backup Object Information > ------------------------- > > SQL Server Name ........................ GBSTPF54 > SQL Database Name ........................ DWHPROD > Backup Object Type ....................... Full > Backup Object State ...................... Active > Backup Creation Date / Time .............. 25-08-2004 22:17:55 > Backup Size .............................. 104,785,560,064 > Database Object Name ..................... 20040825221755\00000998 > Number of stripes in backup object ....... 1 > > SQL Group Logical Name ................... PRIMARY > SQL Group Space Allocated ................ 114,512,822,272 > SQL Group Space Used ..................... 104,743,239,680 > SQL File Logical Name ................... DWH_Data > SQL File Physical Name .................. E:\Microsoft SQL > Server\MSSQL\Data\DW > HPROD.mdf > SQL File Space Allocated ................ 701,956,096 > SQL File Space Used ..................... 648,478,720 > SQL File Logical Name ................... DWH_1_Data > SQL File Physical Name .................. E:\Microsoft SQL > Server\MSSQL\Data\DW > HPROD_1.mdf > SQL File Space Allocated ................ 668,860,416 > SQL File Space Used ..................... 618,528,768 > SQL File Logical Name ................... DWH_2_Data > SQL File Physical Name .................. E:\Microsoft SQL > Server\MSSQL\Data\DW > HPROD_2.mdf > SQL File Space Allocated ................ 113,142,005,760 > SQL File Space Used ..................... 103,476,232,192 > > SQL Group Logical Name ................... TRANSACTION LOG > SQL Group Space Allocated ................ 17,093,885,952 > SQL Group Space Used ..................... 16,693,812,224 > SQL File Logical Name ................... DWH_Log > SQL File Physical Name .................. E:\Microsoft SQL > Server\MSSQL\Data\DW > HPROD_LOG.LDF > SQL File Space Allocated ................ 105,906,176 > SQL File Logical Name ................... DHWPROD_Log > SQL File Physical Name .................. F:\Microsoft SQL > Server\MSSQL\DATA\DH > WPROD_Log.LDF > SQL File Space Allocated ................ 8,493,465,600 > SQL File Logical Name ................... DWHPROD_Log1 > SQL File Physical Name .................. E:\Microsoft SQL > Server\MSSQL\Data\DW > HPROD_Log1_Log.LDF > SQL File Space Allocated ................ 8,494,514,176 > > Using the information fro here I attempted to restore using the > following > command and this is what happens > > C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc restore DWHPROD full > /relocate=DWH_Da > ta,DWH_Log /to=E:\Restore\DWHPROD.mdf,E:\Restore\DHWPROD_Log.LDF > /fromsqlserver= > GBSTPF54 /sqlserver=GBSTPT55 /tsmnode=GBSTPF54_SQL > /tsmpassword=ntbackup > /mountw > ait=yes > > IBM Tivoli Storage Manager for Databases: > Data Protection for Microsoft SQL Server > Version 5, Release 2, Level 1.0 > (C) Copyright IBM Corporation 1997, 2003. All rights reserved. > > Starting Sql database restore... > > Querying Tivoli Storage Manager server for a list of database backups, > please wa > it... > > Restoring metadata ... > > > Waiting for TSM > server.......................................................... > ...................................................................... > ...... > .... > ............. > Beginning full restore of backup object DWHPROD, 1 of 1, > to database DWHPROD > Full: 0 Read: 0 Written: 0 Rate: 0.00 Kb/Sec > Waiting for TSM server....................... > Full: 1 Read: 3145728 Written: 6656 Rate: 0.22 Kb/Sec > Restore of DWHPROD failed. > [Microsoft][ODBC SQL Server Driver][SQL Server]File 'F:\Microsoft SQL > Server\MSS > QL\DATA\DHWPROD_Log.LDF' is on a network device not supported for > database > files > . > [Microsoft][ODBC SQL Server Driver][SQL Server]File 'DHWPROD_Log' > cannot > be rest > ored to 'F:\Microsoft SQL Server\MSSQL\DATA\DHWPROD_Log.LDF'. Use WITH > MOVE to i > dentify a valid location for the file. > [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is > terminating a > bnormally. > > > Total database backups inspected: 1 > Total database backups requested for restore: 1 > Total database backups restored: 0 > Total database skipped: 0 > > Throughput rate: 0.22 Kb/Sec > Total bytes transferred: 6,656 > Elapsed processing time: 30.00 Secs > > ACO0151E Errors occurred while processing the request. > > Am I correct in believeing that the logical files in the primary group > tie > up with the logical files in the Transaction log group from the tsm > query > ? > With the information supplied is it possible to restore by using the > groups, and would it be more straight forward than the way I have been > trying to do it ? > > More importantly does this mean that the problem lies within SQL > itself > rather than TDP for SQL ? > > All help greatly received. > > > > ====================================================================== > ====== > == > This communication, together with any attachments hereto or links > contained > herein, is for the sole use of the intended recipient(s) and may > contain > information that is confidential or legally protected. If you are not > the > intended recipient, you are hereby notified that any review, > disclosure, > copying, dissemination, distribution or use of this communication is > STRICTLY PROHIBITED. If you have received this communication in > error, > please notify the sender immediately by return e-mail message and > delete the > original and all copies of the communication, along with any > attachments > hereto or links herein, from your system. > > ====================================================================== > ====== > == > The St. Paul Travelers e-mail system made this annotation on > 08/27/2004, > 05:31:18 AM. CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.
