Migrating SEPM DB from SQL Server 2005 to 2008 -- do I REALLY have to reinstall SEPM?
We have a SEPM site that currently uses a SQL Server 2005 on an external database server. We need to migrate the database to SQL Server 2008, and I could use some guidance.
The only knowledgebase article I can find on the subject is https://www-secure.symantec.com/connect/blogs/migrating-sepm-db-sql-2008, which actually deal with a migration from an embedded database to SQL Server 2008. These instructions tell me to
- backup the server certificate
- backup the database,
- uninstall SEPM
- Reinstall SEPM
- restore the certificate
- restore the database from backup
These instructions seem reasonable for moving from an embedded database to SQL Server, but they seem like overkill when I'm basically moving from one instance of SQL Server to another. Anyway, I tried the procedure on a small test site and it worked OK. But now I'm trying to migrate our production site, and I'm getting stuck when I try to backup the database. The Database Backup and Restore wizard runs for a while and then fails with the message:
Backup failed writing due to a problem writing to the file system: invalid entry side (expected 94278669 but got 44468000 bytes)
I don't know exactly what this means, but I suspect that the backup is being written to a disk that's running out of space. Unfortunately, this is the server's system disk, and there's not much I can delete to make room for the backup. I would be happy to write the backup to another device (the E: drive has lots of free space) but the database backup program doesn't give me that option. Is there a way to get around this problem?
Ideally, I'd like to avoid jumping through these hoops. Is there a way to move the database from a 2005 server to a 2008 server and modify my site to point to that new server? I'd much prefer to do that, but I don't know how.