Wednesday, March 7, 2012

An easy (but long) restore question

The situation is this. I have a "production test" system, which we are
about to upgrade from 2000SP4 to 2005SP2. The use of the database is to
test fixes, code changes and the like, but it is effectively "pseudo
production" so I have to be careful with it. In effect the user needs
access to the current test data until the upgrade process is complete
and accepted. Since this is my first major upgrade project I am a bit
nervous. Now the issue --
The current database is totally mis-sized, especially the Logfile which
has been allowed to grow to well over 6G of which 3% to 5% is typically
in use. So as a part of this process I would like to resize the target
databases.
My plan is to install a new instance of Sql2005 along-side the existing
2000 instance, on the same server and set of disks. But now I need to
get a copy of the 2000 data over to it. If I back up and restore to an
empty disk location w/ move, I get the existing structure. If I pre-
create the physical structure and restore over it with a move, it will
still overwrite the files and leave me with a copy of the old bad
structure. I know I can go ahead with the copy with move, and then run
the appropriate shrinks and resizing against the copy, but I'd like to
do it in a single process in the interest of time and safety. I've
considered the copy database wizard, but I'm not sure of all of the
ramifications of upgrading to 2005 using a 2000 wizard. I've spent most
of the afternoon researching this in BOL and in 3rd party books. But I
would really appreciate any insights the group might offer and any
advance warnings about "gotcha's" and "show-stoppers."
Thanks in advance.
--
Graham (Pete) Berry
PeteBerry@.Caltech.edusorry for the duplicate post -- it took over 12 hours for the first one
to appear and I got impatient.
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>
Graham (Pete) Berry
PeteBerry@.Caltech.edu

No comments:

Post a Comment