PROSYS SQL BKP

[Solved] PROSYS SQL BKP | Sql - Code Explorer | yomemimo.com
Question : PROSYS SQL BKP

Answered by :

use ERPPRO;
Alter database ERPPRO modify file (name = ERPPRO, newname = ERPPRO_OLD)
Alter database ERPPRO modify file (name = ERPPRO_LOG, newname = ERPPRO_LOG_OLD)
select name, physical_name from ERPPRO.sys.database_files;
alter database ERPPRO set single_user with rollback immediate;
alter database ERPPRO set offline
alter database ERPPRO modify file (name = ERPPRO_OLD, filename = 'D:\DATA\ERPPRO_OLD.mdf')
alter database ERPPRO modify file (name = ERPPRO_LOG_OLD, filename = 'D:\DATA\ERPPRO_LOG_OLD.ldf')
alter database ERPPRO set online;
alter database ERPPRO set multi_user;

Source : | Last Update : Sat, 14 May 22

Answers related to PROSYS SQL BKP

Code Explorer Popular Question For Sql