|
출처 : http://nextstep.co.kr/105
— 백업생성(있으면 생략)
|
BACKUP DATABASE Northwind TO DISK = 'c:\Northwind.bak' |
–백업정보확인(논리적파일명, 물리적저장위치및파일명 확인)
|
RESTORE FILELISTONLY FROM DISK = 'c:\Northwind.bak' |
— TestDB라는 새로운 데이터베이스로 새로운 경로(C:\temptest*.*)으로 복원
|
RESTORE DATABASE TestDB FROM DISK = 'c:\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\testtestdb.mdf', MOVE 'Northwind_log' TO 'c:\testtestdb.ldf' |
[출처] MSSQL 테이블명 , 컬럼명 바꾸기|작성자 zino1187
1.테이블명 바꾸기
|
sp_rename OldTable , NewTable |
2.컬럼명 바꾸기
|
sp_rename 'TableName.OldColumn','TableName.NewColumn' |
[출처] mssql alter table column작성자 재원맨
1. 테이블 필드 수정하기
|
alter table sale alter column title varchar(200) not null |
2. 필드 삭제하기
|
alter table sale drop title |
3. 필드 추가하기
|
alter table sal add sale varchar(20) not null alter table sale add isDel bit DEFAULT 0 not null |
|
"C:\Program Files\Microsoft SQL Server90\Tools\Binn\sqlcmd" -S localhost -i e:\Backupbackup.sql |
풀백업
|
declare @runtime nvarchar(10) declare @backupdevice nvarchar(100) declare @backupname nvarchar(100) set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2) set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak' set @backupname = N'backup_' + @runtime BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10 |
증분 백업
|
declare @runtime nvarchar(10) declare @backupdevice nvarchar(100) declare @backupname nvarchar(100) set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2) set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak' set @backupname = N'backup_' + @runtime BACKUP DATABASE [TU] TO DISK = @backupdevice WITH DIFFERENTIAL, NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10 |
|
링크
|