Hi.
I want to do this:
Restore prod backup into #temp-db
ADAORD RESTRUCTEREF a bunch of files
(single user or multi user - not sure yet - any benefits of parallel processing files?)
ADADEF DEFINE #temp-db with RABNSIZE 4
Increase #temp-db
ADAORD STORE into #temp-db
(single user or multi user - not sure yet - any benefits of parallel processing files?)
TAKE PLOGS from prod DB and apply them against #temp-db
Rename prod-db to old-db
Rename #temp-db to prod-db
SO MY QUESTIONS IS THIS:
Presumably applying PLOG requires that ISNs do not change during ADAORD RESTRUC… and ADAORD STORE - DOES THIS PROCESS RETAIN THE ISNS??? ALWAYS??? IF ONLY SOMETIMES DOES IT DEPEND ON SETTING OF USERISN AT THE FILE LEVEL?
Is this a recognised/accepted strategy??? It will take 48 hours to execute and as 24/7 (mostly) I can;t be out for 2 days.
I plan to do first ADAORD on weekend 1 and second ADAORD during week and apply PLOGs through the week and on second weekend flip to new db.
Thanks!
D.G.
A DBA