Any way I can do a quick interim cleanup / defrag of the content database?
Ken Thompson IT Support - Systems Administrator HomeGround Services 68 Oxford Street, Collingwood, VIC 3066 Tel: 03 9288 9668 (Ex 668) Mob: 0404 852 325 Fax: 03 9419 1876 www.homeground.org.au <http://www.homeground.org.au> ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Paul Noone Sent: Tuesday, 13 April 2010 8:19 AM To: ozMOSS Subject: RE: 32/64 bit SQL Server...issues? The content databases should be a breeze. I've now done it multiple times to resolve various issues (aside from migration) and it's a simple matter. The config databases - Central Admin and SSP - are more problematic and I'd recommend rebuilding these and any web apps from your build doc. Then just reattach the migrated content DBs, run a full search and you're on your way. Regards, Paul Online Developer, ICT CEO Sydney From: [email protected] [mailto:[email protected]] On Behalf Of Wes MacDonald Sent: Monday, 12 April 2010 9:36 PM To: ozMOSS Subject: RE: 32/64 bit SQL Server...issues? Hi, I wanted to point out that SQL 2005 x32 => SQL 2005 x64 Upgrade is indeed supported. "The move from 32-bit SQL Server to 64-bit SQL Server is seamless. Both editions of SQL Server use the same on-disk structures; you simply need to detach the databases for the 32-bit system, then attach them to the 64-bit system." http://msdn.microsoft.com/en-us/library/cc966519.aspx <http://msdn.microsoft.com/en-us/library/cc966519.aspx> Wes Wes MacDonald LIKE 10 INC. <http://www.like10.ca/> 1150 - 45 O'Connor Street Ottawa, ON K1P 1A4 Microsoft MVP: Visual Studio ALM <https://mvp.support.microsoft.com/profile/Wes.MacDonald> | Blog <http://wesmacdonald.spaces.live.com/> | Mobile: 613.219.7841 | Office: 613.755.4055 | MSN <mailto:[email protected]> "Risk comes from not knowing what you're doing. " -- Warren Buffet ________________________________ From: [email protected] [[email protected]] On Behalf Of Ken Thompson [[email protected]] Sent: Monday, April 12, 2010 2:43 AM To: [email protected] Subject: 32/64 bit SQL Server...issues? Hey Guys, So our MOSS 2007 installation is setup on a 64bit Win 2008 R2 host. SQL Server Express is installed on there. I want to migrate the databases to our main databases server, SQL 2005....is this even possible? Or am I going to need to install a 64 bit SQL to port it to..... Cheers, Ken Thompson IT Support - Systems Administrator HomeGround Services 68 Oxford Street, Collingwood, VIC 3066 Tel: 03 9288 9668 (Ex 668) Mob: 0404 852 325 Fax: 03 9419 1876 www.homeground.org.au <http://www.homeground.org.au/>
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
