its sql2000. what if i dont know all passwords? i can get in to cfadmin on both dev & prod. but not sa on both sql serves. i can vpn in most boxes, but dont have admin pass on the boxes. so have to figure out them... since they are locked...
seriously i would pay some one to clean this shit up. but i am not sure if i am a real manager, or just a guy to fix it, and then get shit canned. but its great to do some coldfusion code again! i am loving that. seems i am pretty average at it which is great! its the dba & admin stuff i suck at! On Dec 22, 2007 5:30 PM, William Bowen <[EMAIL PROTECTED]> wrote: > > all in 3 days next week! > > They are paying you big bucks for this, yes? > > ;-) > > For IIS you can save the site as a template (if you have multiple > sites, save each as a template). The put those templates in a known > "staging" location on the new server, pelsonnally I create a folder > "0" (zero) in each drive on a server. I put junk in there. It always > sorts to the top. > > For CFMX, you can use the neo*.xml file trick mentioned earlier. > > For SQLServer, do a backup of each DB to a known location, stop the > DBs and then transfer the MDF and LDF files to the new storage > location on the new hardware. > > Then in SQL Server Management Console (assuming 2005 SP1) Restore the > DB files (mdf and ldf) from the new storage areas. Be careful to note > the collation on the old server. > > FWIW, I just took the SQL Server 2005 Performance Tuning & > Optimization Workshop Plus from Microsoft over the last four days. > Well worth the time and investment. > > HTH, and send more questions as needed. > > :-) > -- > will > > "If my life weren't funny, it would just be true; > and that would just be unacceptable." > - Carrie Fisher > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:248948 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
