Tag archives for SharePoint

Just remembered too how stupid I was doing the restore. First time round I had installed SQL Server 2008, and then used the Standalone Server option in the SharePoint setup. That installs SQL 2005 and uses that! Means that wehn you try and restore the databases to your SQL 2008 instance, it will error saying that you do not have permissions to Create Database. Must keep better notes of what I am doing.

Had only just read about choosing the Full installation if using your own SQL instance too!!

Be the first to like.

Mark this post as useful.

Unmark this post as useful.

We have upgraded our SharePoint server from Windows Server 2003 32bit to Windows 2008 64bit. This, on the face of it seemed like a reasonably effortless task, requiring some planning, but principly, install new server, install SharePoint, move SharePoint using a backup and a restore, and then re-deploy the Application Templates.

All was going well. Windows installed and configured, SharePoint installed as per Microsoft guide for migration. The backup had gone perfectly. Now for the restore. The tension was killing me. All should have been fireworks and working, but…..no.

In a good way, the restore will not let you overwrite any exisitng databases, or SSP’s. But also, every time that it goes wrong, you have to go and remove everything that it did successfully manage to restore. So annoying.

Anyway, after a lot of frustrating restores, entering in usernames, passwords, SQL server names and paths, it works, and our Intranet is back.

What a stupid system though. Needs a lot of refinement. Don’t let the seamless backup procedure fool you into thinking that a restore is going to be that easy!

Be the first to like.

Mark this post as useful.

Unmark this post as useful.