Thursday, June 7, 2012

Restore MOSS content database

1. After the new server is installed, no content database.
2. In central admin, Create a new web application at port 80, named wss_content (default)
configurable username and password: pxxxadmin/xxxxx
3. In SQL management studio, r-click databases and select restore database and select wss_content
4. point to bk file and ok to restore
5. got error

6. stop sql service, rename wss_content.mdf and wss_content_log.ldf and try (see screenshot, error1)
7. remove content datbase in central admin>app mgt>content database
8 then i got another error (see screenshot error2)


once removed content db from central admin
stop sql services and delte wss_content.mdf and ldf
restore again and make sure go to options to select overwrite
restored successfully this time

STSADM –o addcontentdb –url <URL name> -databasename <database name> -databaseserver <database server name>
but got error

The specified SPContentDatabase Name=WSS_CONTENT Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.

verison is 12.0.6425.1000 on both servers!??
run config wizard again

verison on new moss is 12.0.0.6421
on old server is 12.0.0.6565
http://insomniacgeek.com/how-to-determine-the-installed-sharepoint-version/
requested and installed KB2553020 - failed as well
try KB2596541 - 12.0.0.6653 - WTF
well "Operation completed successfully"

Domain Account Keeps locking out

One domain user's account keeps locking out. I have checked the credential manager to remove all without luck till I found this article ...