3월, 2014

3 03 2014

법인 – 시스템개발 내역서

Haeng Ho Kang | Document, Company | 0

08. 시스템개발 내역서

3 03 2014

법인 사용인감계/위임장

Haeng Ho Kang | Document, Company | 0

사용인감계 위임장(별지제3호양식)

3 03 2014

MS-SQL Column 추가,수정, 외부키

Haeng Ho Kang | DataBase, MS-SQL | 0

alter table 테이블명
add USERIP varchar(50);

alter table 테이블명
drop column userip;

ALTER TABLE 테이블1
ADD CONSTRAIN FK_Code FOREIGN KEY(code)
REFERENCES 테이블2(code)

alter table 테이블명

add USERIP varchar(50);

alter table 테이블명

drop column userip;

ALTER TABLE 테이블1

ADD CONSTRAIN FK_Code FOREIGN KEY(code)

REFERENCES 테이블2(code)

3 03 2014

MS-SQL 백업 및 복원

Haeng Ho Kang | DataBase, MS-SQL | 0

restore filelistonly from disk = 'D:\db_backup\ABCD\ABCD.backup'

RESTORE DATABASE ABCD FROM DISK = 'D:\db_backup\ABCD\ABCD.backup'
with move 'LIV_Data' TO 'D:\Microsoft SQL Server\MSSQL\Data\ABCD.mdf',
move 'LIV_Log' TO 'D:\Microsoft SQL Server\MSSQL\Data\ABCD_log.ldf'

restore filelistonly from disk = 'D:\db_backup\ABCD\ABCD.backup'

RESTORE DATABASE ABCD FROM DISK = 'D:\db_backup\ABCD\ABCD.backup'

with move 'LIV_Data' TO 'D:\Microsoft SQL Server\MSSQL\Data\ABCD.mdf',

move 'LIV_Log' TO 'D:\Microsoft SQL Server\MSSQL\Data\ABCD_log.ldf'

실제물리적경로와 이름이 같아야 복원이 됨 이런식으로 뒤에 물리적 경로를 다른곳으로 저장해도 됩니다. restore filelistonly from disk = ‘G:\ABCD.bak’ 백업하기 backup database bcd to disk = ‘D:\backup-db\abc20121108.bak’ 백업본은 안됨 MSSQL2000 –> 2012업데이트할경우는 먼저 2005, 2008로 2005==> 2012로 업데이트할경우 1.백업본은 안됨 2.mdf,ldf만 됨 1.오픈라인시킴 2.기존과 동일한 위치에 두고 할것 ndf가 남은 경우

RESTORE DATABASE KDAIACDP FROM DISK = 'D:\DataBaseFiles\ProfilerPlus_20121118.bak'
with move 'ProfilerPlus_Data' TO 'D:\DataBaseFiles\KDAIACDP_data.mdf',
move 'ftrow_idx' TO 'D:\DataBaseFiles\KDAIACDP_idx.ndf',
move 'ProfilerPlus_Log' TO 'D:\DataBaseFiles\KDAIACDP_log.ldf'

RESTORE DATABASE KDAIACDP FROM DISK = 'D:\DataBaseFiles\ProfilerPlus_20121118.bak'

with move 'ProfilerPlus_Data' TO 'D:\DataBaseFiles\KDAIACDP_data.mdf',

move 'ftrow_idx' TO 'D:\DataBaseFiles\KDAIACDP_idx.ndf',

move 'ProfilerPlus_Log' TO 'D:\DataBaseFiles\KDAIACDP_log.ldf'

MDF/NDF/LDF […]

3 03 2014

MS-SQL DB생성 및 권한설정

Haeng Ho Kang | DataBase, MS-SQL | 0

create database spring;
grant all on spring.* to spring@'%' identified by 'spring';
grant all on spring.* to spring@'localhost' identified by 'spring';
use spring;

create database spring;

grant all on spring.* to spring@'%' identified by 'spring';

grant all on spring.* to spring@'localhost' identified by 'spring';

use spring;

3 03 2014

MS-SQL – BACKUP

Haeng Ho Kang | DataBase, MS-SQL | 0

BACKUP DATABASE abc TO DISK = 'H:/backup/abc.backup' WITH INIT;

BACKUP DATABASE pia TO DISK = 'H:/backup/pia.backup' WITH INIT; 
BACKUP DATABASE pubs TO DISK = 'H:/backup/pubs.backup' WITH INIT; 

시스템백업용도 
BACKUP DATABASE Northwind TO DISK = 'H:/backup/Northwind.backup' WITH INIT; 
BACKUP DATABASE master TO DISK = 'H:/backup/master.backup' WITH INIT; 
BACKUP DATABASE model TO DISK = 'H:/backup/model.backup' WITH INIT; 
BACKUP DATABASE msdb TO DISK = 'H:/backup/msdb.backup' WITH INIT; 
BACKUP DATABASE tempdb TO DISK = 'H:/backup/tempdb.backup' WITH INIT;