|
Replies:
3
-
Pages:
1
-
Last Post:
Apr 26, 2012 6:21 AM
by: Alexander.Maximov
|
|
|
Posts:
760
Registered:
3/16/09
|
|
|
|
Toad-SS 5.7 Beta issue with Restore File location, a continuation from Toad-SS 5.6 release
Posted:
Apr 16, 2012 8:20 AM
|
|
|
|
|
Note: This issue and the graphics below are best viewed by an outlook email
transport as opposed to the Yahoo.com email service.
There are many tables explanations associated with the graphics to the right to
review. Hopefully all the detail needed to see the problem has been included.
In Toad-5.6 there were several accept issue concerning database restore and the
handling of the Logical and Restore as file location.
The current code in 5.7 beta doesn’t solve the problem but exacerbates the
restore to another set of problems.
There are new buttons for backup which will be explored during the Beta process,
but my concern here is that that the Toad-SS-5.7 code has taken the reported
problems and attempted to resolve the accepted issues but now has continued down
a path that is not usable by the user community.
I hope the below “To the Point” distinction suffices. If needed
please get with Gita in support about the original submissions on Restore
concerning Toad-SS 5.6.
Lastly, I would like to work with the developer directly on these backup and
restore issues and get what I believe would be a more satisfactory set of toad
code in these area.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
Toad-SS 5.6
Toad SS 5.7
When you change the Database name on a Restore in Toad SS- 5.6 the restore of
GCMA as GCMA_DBA(Empty), populates the Restore as File location.
Toad-SS 5.7 Does nothing correct. So I have to manually make the change to give
the following results.
/* The below is not system generated but a combo of generation and manual
correction */
RESTORE DATABASE [GCMA_DBA(Empty)] FROM
DISK = N'T:\Hank(DBA)\Keepers\GCMA(for
FV_Load_(Purged)_Before_FKeyFix)_13-Apr-2012(2).bak'
WITH FILE = 1 ,
--- This is the incorrect code generated by the restore wizard.
--MOVE N'GCMA_Data' TO N'F:\MSSQL\GCMATM_B1\Data\GCMA_DBA(Empty)_1.mdf' ,
--MOVE N'GCMA_Data2' TO N'F:\MSSQL\GCMATM_B1\Data\GCMA_DBA(Empty)_2.ndf' ,
--MOVE N'GCMA_Data3' TO N'F:\MSSQL\GCMATM_B1\Data\GCMA_DBA(Empty)_3.ndf' ,
--MOVE N'GCMA_Log4' TO N'G:\MSSQL\GCMATM_B1\LOGS\GCMA_DBA(Empty)_4.ldf' ,
-- This is the operational code I created after the wizard made the above.
MOVE N'GCMA_Data' TO N'L:\MSSQL\GCMATM_B1\Data\GCMA_DBA(Empty)_1.mdf' ,
MOVE N'GCMA_Data2' TO N'L:\MSSQL\GCMATM_B1\Data\GCMA_DBA(Empty)_2.ndf' ,
MOVE N'GCMA_Data3' TO N'L:\MSSQL\GCMATM_B1\Data\GCMA_DBA(Empty)_3.ndf' ,
MOVE N'GCMA_Log4' TO N'K:\MSSQL\GCMATM_B1\LOGS\GCMA_DBA(Empty)_4.ldf' ,
----
RECOVERY,
NOUNLOAD ,
REPLACE ,
STATS = 10
GO
Here is the code generated by Toad-SS 5.7 where I have change the To database
Name and Toad does nothing to change the Restore as file. If I performed the
script there real GCMA database may be compromised.
Here is where I have cut and paste the new database name into the mdf, ndf and
ldf … It looks real good until you get to step #5,
After step #5, all the drive locations go back to F:\ and G:\ which is not what
should be generated.
This too will generate an undesirable response if the script or wizard is run,
the underlying database file can get associated with the wrong database name or
at best the script and wizard fail if the files are in use…
Lastly, I have included the script I use to validate the database file locations
the sp_helpfile should be already understood
SELECT
name AS [Logical Name] ,
physical_name AS [DB File Path] ,
type_desc AS [File Type] ,
state_desc AS [State]
FROM sys.master_files
WHERE database_id = DB_ID ( N'GCMA_DBA(Empty)' ) order by 1
GO
use [GCMA_DBA(Empty)]
go
sp_helpfile
|
|
|
Posts:
794
Registered:
6/16/10
|
|
|
|
RE: Toad-SS 5.7 Beta issue with Restore File location, a
continuation from Toad-SS 5.6 release
Posted:
Apr 17, 2012 6:34 AM
in response to: hfreeman
|
|
|
|
|
Hank,
Thank you for the detailed valuable report. Some of reported items are known
issues and already in=progress. We created several new CRs to fix issues you
mentioned. Will try to implement shortly.
regards,
Alexander Maximov
|
Alexander Maximov, DELL
|
|
Posts:
760
Registered:
3/16/09
|
|
|
|
RE: RE: Toad-SS 5.7 Beta issue with Restore File location, a continuation from Toad-SS 5.6 release
Posted:
Apr 17, 2012 6:43 AM
in response to: Alexander.Maximov
|
|
|
|
|
Thanks Alex!
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
|
|
|
Posts:
794
Registered:
6/16/10
|
|
|
|
Re: RE: RE: Toad-SS 5.7 Beta issue with Restore File location, a continuation from Toad-SS 5.6 release
Posted:
Apr 26, 2012 6:21 AM
in response to: hfreeman
|
|
|
Hank,
most issues in Restore DOE were fixed. Please check out next beta build and report in any issues.
It suppose to be posted later today (we expiriencing some environment issues)
Alex
|
Alexander Maximov, DELL
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
