Move contentstore database to a remote server

[blom0344]

What is the best practice in case one needs to move the physical database that houses the contentstore from a local sql 2000 server to a dedicated sql server 2005 database?

And what needs to be adjusted in Cognos Configuration? 

[ducthcogtechie]

- Backup the sql 2000 content store database.
- Restore this backup on the sql 2005 database server.
- Create the same sql user as used on the old database server with the same password.
- Run the following stored procedure on the restored DB on the sql 2005:
  EXECUTE sp_change_users_login 'Update_One', 'sqlusername', 'sqlusername'
- In Cognos Configuration chage the servername, and if needed the DB name (if not restored using the same name)

Otherwise you can also:
- Export the public folders with all info needed
- Create a new empty content store.
- Start the service and afterwards clean out all the "everyone" groups from the cognos namespace.
- import the pulbic folders with all info needed

The result should be the same. The first is less work.