//Steps to restore model,Transactional database files(.bak):- 1)First shrink the both model,Transactional Database to get free space //get SID use master; select * from [ABC_AX_DEV].[dbo].[USERINFO] where id = 'Admin' //The following are the SQL commands: use master //for Transactional Database USE [ABC_AX_DEV] select file_id, name from sys.database_files dbcc shrinkfile(2,7) dbcc shrinkdatabase(1,7) //for model use [ABC_AX_DEV_model] select file_id, name from sys.database_files dbcc shrinkfile(2,7) dbcc shrinkdatabase(1,7) 2)select model restore-->device-->selct your ".bak" file--->do the below steps check OverWrite the existing database(WITH REPLACE). check close existing connections to destination database. 3)do the same steps for Transactional Database 4) if u get error after restored your DB,model "failed to logon MicrosoftDynamics AX" Please get your old DB,model SID and update now. UPDAT...
Posts
Showing posts from July, 2016