June 17, 2005 at 7:51 am
Ok,
I am running SQL Server 2000 Ent SP3a.
It is running all of our Peoplesoft environment without glitch. I'll have everyone note that I moved us from Oracle 9i r2 for both the HRMS and Finance systems (versions 8.8) and we are running faster and with smaller databases as well (you go SQL Server).
Anyway during the upgrade I had to keep dropping and renaming databases per Peoplesoft instructions. When I was all finished I had the following...
Started out with a database name of :
FSPRDCPY - The log files and MDF files matched this.
I then had to offline this, copy the entire structure for backup and then when we went live I created a new database called FSPRD. I then simply took the Log and MDF files from FSPRDCPY and renamed it to FSPRD_Data and FSPRD_Log respectively (pointing to the correct location of course) and started up.
All went perfect and runs great.
Except!
When I try to truncate logs and shrink DB sizes the system tables still report the old FSPRDCPY name instead of the new FSPRD name. I looked in the system tables and found the entries but am unable to alter them to the new FSPRD structure. Does anyone know of a way to do this?
Thanks,
SS
June 17, 2005 at 8:26 am
Ugh, I didn't even notice I was in the 2005 area, will post approriately, please disregard!!!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply