Re: SQL Restore Error
Hello, I am still on TDP 1.?, but I think you have specify different file location in the restore option if your directory structure are different between the two servers. Yi [EMAIL PROTECTED] 04/01/03 01:30PM SQL Version 7 TDP Version 2.2.1 Trying to restore SQL Database onto another SQL Server but I am getting this error ACO0151E Restore failed [Microsoft] ODBC SQL Server Driver...The file cannot be used by RESTORE..Consider using With MOVE Option to identify a valid Location. What am I doing wrong Mehdi Amini LAN/WAN Engineer ValueOptions 12369 Sunrise Valley Drive Suite C Reston, VA 20191 Phone: 703-390-6855 Fax: 703-390-2581 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.If you have received this email in error please notify the sender by email, delete and destroy this message and its attachments. **
Re: SQL Restore Error
Here's an example of a restore that relocates/renames the database and log pieces: tdpsqlc restore ServiceCenter3 full /into=ServiceCenterTemp /replace /relocate=ServiceCenter1_Data,ServiceCenter1_Log /to=g:\mssql7\data\servicecentertemp_data.mdf,g:\mssql7\data\servicecenterte mp_log.ldf The /relocate= values are found from doing a QUERY TSM /FILEINFO command. You'll probably have to specify from /FROMSERVER= parameter, too. The above command restores the most recent backup of the production database into a test instance. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Ung Yi Sent: Wednesday, April 02, 2003 9:33 AM To: [EMAIL PROTECTED] Subject: Re: SQL Restore Error Hello, I am still on TDP 1.?, but I think you have specify different file location in the restore option if your directory structure are different between the two servers. Yi [EMAIL PROTECTED] 04/01/03 01:30PM SQL Version 7 TDP Version 2.2.1 Trying to restore SQL Database onto another SQL Server but I am getting this error ACO0151E Restore failed [Microsoft] ODBC SQL Server Driver...The file cannot be used by RESTORE..Consider using With MOVE Option to identify a valid Location. What am I doing wrong Mehdi Amini LAN/WAN Engineer ValueOptions 12369 Sunrise Valley Drive Suite C Reston, VA 20191 Phone: 703-390-6855 Fax: 703-390-2581 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.If you have received this email in error please notify the sender by email, delete and destroy this message and its attachments. **
SQL Restore Error
SQL Version 7 TDP Version 2.2.1 Trying to restore SQL Database onto another SQL Server but I am getting this error ACO0151E Restore failed [Microsoft] ODBC SQL Server Driver...The file cannot be used by RESTORE..Consider using With MOVE Option to identify a valid Location. What am I doing wrong Mehdi Amini LAN/WAN Engineer ValueOptions 12369 Sunrise Valley Drive Suite C Reston, VA 20191 Phone: 703-390-6855 Fax: 703-390-2581 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.If you have received this email in error please notify the sender by email, delete and destroy this message and its attachments. **
Re: SQL Restore Error
Mehdi, Look at the /RELOCATE and /TO options. (... or the right-mouse click while the backup to restore is selected.) This allows you to move the database to a different physical location. Thanks, Del SQL Version 7 TDP Version 2.2.1 Trying to restore SQL Database onto another SQL Server but I am getting this error ACO0151E Restore failed [Microsoft] ODBC SQL Server Driver...The file cannot be used by RESTORE..Consider using With MOVE Option to identify a valid Location. What am I doing wrong
Re: SQL Restore Error
Since My email, I did exactly as you recommed and it worked. THanks so much Mehdi Amini LAN/WAN Engineer ValueOptions 12369 Sunrise Valley Drive Suite C Reston, VA 20191 Phone: 703-390-6855 Fax: 703-390-2581 -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:07 PM To: [EMAIL PROTECTED] Subject: Re: SQL Restore Error Mehdi, Look at the /RELOCATE and /TO options. (... or the right-mouse click while the backup to restore is selected.) This allows you to move the database to a different physical location. Thanks, Del SQL Version 7 TDP Version 2.2.1 Trying to restore SQL Database onto another SQL Server but I am getting this error ACO0151E Restore failed [Microsoft] ODBC SQL Server Driver...The file cannot be used by RESTORE..Consider using With MOVE Option to identify a valid Location. What am I doing wrong ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.If you have received this email in error please notify the sender by email, delete and destroy this message and its attachments. **
Re: FW: TDP SQL Restore Error
Thanks Del. Problem with MAXMUMMP. Fixed now. However I now get the following: 24-02-2003 13:23:50 ACO5456W The backup is corrupt and is not fully restorable. 24-02-2003 13:23:50 Processing will continue. 24-02-2003 13:23:50 ACO0302E A failure occured on stripe number (3), rc = 428 24-02-2003 13:23:50 ACO5407E The SQL server aborted the operation. 24-02-2003 13:23:50 ACO0302E A failure occured on stripe number (2), rc = 428 24-02-2003 13:23:50 ACO5407E The SQL server aborted the operation. 24-02-2003 13:23:54 ACO0302E A failure occured on stripe number (0), rc = 428 24-02-2003 13:23:54 ACO5407E The SQL server aborted the operation. 24-02-2003 13:24:54 ACO0302E A failure occured on stripe number (1), rc = 428 24-02-2003 13:24:54 ACO5407E The SQL server aborted the operation. 24-02-2003 13:24:55 ACO5407E The SQL server aborted the operation. 24-02-2003 13:24:55 Restore of PrecisePW failed. 24-02-2003 13:24:55 ACO5407E The SQL server aborted the operation. 24-02-2003 13:24:55 Total database backups inspected: 1 24-02-2003 13:24:55 Total database backups requested for restore: 1 24-02-2003 13:24:55 Total database backups restored:0 24-02-2003 13:24:55 Total database skipped: 0 24-02-2003 13:24:55 Throughput rate:0.00 Kb/Sec 24-02-2003 13:24:55 Total bytes transferred:0 24-02-2003 13:24:55 Elapsed processing time:65.02 Secs 24-02-2003 13:24:55 ACO0151E Errors occurred while processing the request. I'm talk to my SQL DBA tells me that the test restore worked before the data was migrated to tape. Any ideas? Thanks in advance. Rizwan Shamim Central Backup Service (CBS) Merrill Lynch Europe PLC Tel: 020 7995 1176 Mobile: 0787 625 8246 mailto:[EMAIL PROTECTED] For very important information relating to this e-mail please click on this link: http://www.ml.com/legal_info.htm -Original Message- From: Del Hoobler [SMTP:[EMAIL PROTECTED] Sent: Thursday, February 20, 2003 7:27 PM To: [EMAIL PROTECTED] Subject: Re: FW: TDP SQL Restore Error Rizwan, RC=418 means there was a problem with the TSM API. Take a look at the TSM Server activity log to see why it terminated the sessions. It could be that the volumes were not available or there were not enough mountpounts defined to satisfy the request. ... Or MAXNUMMP was not set high enough to fulfill the multiple stripe restore request. If you cannot figure out what the problem is, please calll IBM support. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Remember that the best job security is doing a job well and doing it cheerfully. I'd be grateful if someone could shed some ligh on this: 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (4), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (0), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure
Re: FW: TDP SQL Restore Error
Rizwan, This means that some of the data objects needed for the restore cannot be found in the TSM Server database. If the restore worked prior to the migration to tape, the backup must have been good. And so, something must have happened that caused some of those objects to be deleted or corrupted. (for example, a bad tape, etc.) If you are trying to get this process working, I would start with a single stripe backup, let it migrate to tape, and then try the restore. Make sure it works with a single stripe to verify the procedure, then increase the stripes to make sure your setup is correct. If you continue to have problems, please call IBM support. Deleted objects are serious business and indicate that something else is going wrong with your TSM Server. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Remember that the best job security is doing a job well and doing it cheerfully. 24-02-2003 13:23:50 ACO5456W The backup is corrupt and is not fully restorable. I'm talk to my SQL DBA tells me that the test restore worked before the data was migrated to tape.
Re: FW: TDP SQL Restore Error
Thanks for your help Del. We have tested with 4 stripes and we restored at around 28-31MB/sec previously from tape (3590E XL). I'll call IBM. Thanks again. Rizwan Rizwan Shamim Central Backup Service (CBS) Merrill Lynch Europe PLC Tel: 020 7995 1176 Mobile: 0787 625 8246 mailto:[EMAIL PROTECTED] For very important information relating to this e-mail please click on this link: http://www.ml.com/legal_info.htm -Original Message- From: Del Hoobler [SMTP:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 2:51 PM To: [EMAIL PROTECTED] Subject: Re: FW: TDP SQL Restore Error Rizwan, This means that some of the data objects needed for the restore cannot be found in the TSM Server database. If the restore worked prior to the migration to tape, the backup must have been good. And so, something must have happened that caused some of those objects to be deleted or corrupted. (for example, a bad tape, etc.) If you are trying to get this process working, I would start with a single stripe backup, let it migrate to tape, and then try the restore. Make sure it works with a single stripe to verify the procedure, then increase the stripes to make sure your setup is correct. If you continue to have problems, please call IBM support. Deleted objects are serious business and indicate that something else is going wrong with your TSM Server. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Remember that the best job security is doing a job well and doing it cheerfully. 24-02-2003 13:23:50 ACO5456W The backup is corrupt and is not fully restorable. I'm talk to my SQL DBA tells me that the test restore worked before the data was migrated to tape.
FW: TDP SQL Restore Error
Greetings, Our current environment: TSM on Solaris: TSM version 4.2.3.1 SQL TDP Client:TDP version 2.2.0.01 TSM BA Client:TSM version 4.2.1.22 We recieved the following TDP errorrs in our client logs. I'd be grateful if someone could shed some ligh on this: 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (4), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (0), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (6), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (1), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (2), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (3), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (5), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:44 Restore of PrecisePW failed. 18-02-2003 16:15:44 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:44 Total database backups inspected: 1 18-02-2003 16:15:44 Total database backups requested for restore: 1 18-02-2003 16:15:44 Total database backups restored:0 18-02-2003 16:15:44 Total database skipped: 0 18-02-2003 16:15:44 Throughput rate:3.22 Kb/Sec 18-02-2003 16:15:44 Total bytes transferred: 31,457,280 18-02-2003 16:15:44 Elapsed processing time: 9,529.56 Secs 18-02-2003 16:15:44 ACO0151E Errors occurred while processing the request. Thanks in advance. Riz
Re: FW: TDP SQL Restore Error
Rizwan, RC=418 means there was a problem with the TSM API. Take a look at the TSM Server activity log to see why it terminated the sessions. It could be that the volumes were not available or there were not enough mountpounts defined to satisfy the request. ... Or MAXNUMMP was not set high enough to fulfill the multiple stripe restore request. If you cannot figure out what the problem is, please calll IBM support. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Remember that the best job security is doing a job well and doing it cheerfully. I'd be grateful if someone could shed some ligh on this: 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (4), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (0), rc = 418 18-02-2003 16:15:43 ANS1017E (RC-50) Session rejected: TCP/IP connection failure
sql restore error(urgent..)
Check following error message out. How does it works?? I'am in trouble now,give me a clear answer.. Thanks in advance.. ACO3028e SQL server errors encountered. DB-LIB messages: Because db is in use. you cannot access alone..
Re: sql restore error(urgent..)
$)C Iykim, This isn't a lot to go by... but I suggest that you reboot the server, make sure nothing/no one opens the database that you are trying to restore, then retry the restore operation. If it still fails, you will have to find out what process has the database open and make sure that process releases it, so you can do your restore successfully. If you cannot get this to work, I suggest calling IBM/Tivoli support. We may also have to get Microsoft involved... Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] It's a beautiful day. Don't let it get away. -- Bono 1h@N?1 iykim@CDDATA. To: [EMAIL PROTECTED] CO.KR cc: Sent by: Subject: sql restore error(urgent..) ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 02/28/2001 03:02 AM Please respond to ADSM: Dist Stor Manager Check following error message out. How does it works?? I'am in trouble now,give me a clear answer.. Thanks in advance.. ACO3028e SQL server errors encountered. DB-LIB messages: Because db is in use. you cannot access alone..
