Posted on November 30, 2014 at 10:32 PM
For this post lets make a reminder on how to restore tridion databases using SQL Server. I have done this many time in the past and probably will in the future so this post will be a good source of information.
Before starting database restore, the services below needs to be stopped (on CM machine):
Restore Tridion database from the backup, one at a time.
To complete the restore some scripts must be executed using SQL Server Management Studio in order for Tridion to work properly.
USE Tridion_cm GO sp_change_users_login 'Auto_Fix', 'TCMDBUser' GO USE Tridion_Broker GO sp_change_users_login 'Auto_Fix', 'TridionBrokerUser' GO
USE Tridion_cm; TRUNCATE TABLE dbo.PUBLISH_STATES; TRUNCATE TABLE dbo.QUEUE_MESSAGES; TRUNCATE TABLE dbo.QUEUE_FILTERS; TRUNCATE TABLE dbo.PUBLISH_TRANSACTIONS;
After logging to Tridion update configuration for publication target if needed and clean the web server from pages that were published before database restore was done.