Search
 
SCRIPT & CODE EXAMPLE
 

SQL

PROSYS SQL BKP


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;



Comment

PREVIOUS NEXT
Code Example
Sql :: postgres get size of database 
Sql :: reset ids in mysql 
Sql :: find sp name by text in sql server 
Sql :: uninstall mysql ubuntu 
Sql :: postgres get running query 
Sql :: postgresql create table default value timestamp 
Sql :: alter user mysql native password 
Sql :: oracle get table schema 
Sql :: django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1. 
Sql :: mysql_secure_installation 
Sql :: uninstall mysql on ubuntu 
Sql :: set max_allowed_packet mysql 
Sql :: commentaire table oracle 
Sql :: how to edit table name in mysql 
Sql :: force drop all tables postgres 
Sql :: get all schemas postgres 
Sql :: pl sql escape & 
Sql :: find mysql version linux 
Sql :: Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1 
Sql :: mysql interval 1 day 
Sql :: created at and updated at in mysql 
Sql :: sql skip the first row 
Sql :: mariadb get column names from table 
Sql :: PLS-00225 type 
Sql :: how to add a index to live table mysql 
Sql :: group_concat max length mysql 
Sql :: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement 
Sql :: oracle list next running jobs 
Sql :: select item.* as json mysql 
Sql :: console output pl sql 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =