Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

PROSYS SQL


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:DATAERPPRO_OLD.mdf')
alter database ERPPRO modify file (name = ERPPRO_LOG_OLD, filename = 'D:DATAERPPRO_LOG_OLD.ldf')
alter database ERPPRO set online;
alter database ERPPRO set multi_user;
 
PREVIOUS NEXT
Tagged: #PROSYS #SQL
ADD COMMENT
Topic
Name
7+6 =