2022. 2. 18. 15:32
공부용 링크
2022. 2. 7. 15:24
SQL SERVER
restore filelistonly from disk='H:\temp\DBNAME_FULL2.BAK'
restore database DBNAME from disk='H:\temp\DBNAME_FULL2.bak'
with move 'TEST_Data' to 'K:\SQL_DATA\DBNAME.MDF',
move 'TEST_Data_Log' to 'N:\LOG_DATA\DBNAME_log.LDF'
--논리적이름 변경
ALTER DATABASE DBNAME MODIFY FILE ( NAME = 과거이름_Data, NEWNAME = DBNAME );
GO
ALTER DATABASE DBNAME MODIFY FILE ( NAME = 과거이름_Log, NEWNAME = DBNAME_LOG );
GO
--자동증가 변경
ALTER DATABASE DBNAME
MODIFY FILE ( NAME = 'DBNAME', FILEGROWTH = 128MB )
GO
ALTER DATABASE DBNAME
MODIFY FILE ( NAME = 'DBNAME_log', FILEGROWTH = 64MB )
GO
--vlf설정 최적화(가능하다면)
dbcc loginfo('DBNAME')
ALTER DATABASE DBNAME SET RECOVERY simple
use DBNAME
dbcc shrinkfile ('DBNAME_log', 0, TRUNCATEONLY) --로그파일 갯수를 줄인다.
ALTER DATABASE DBNAME MODIFY FILE (NAME = N'DBNAME_log' , SIZE = 256MB); --로그파일 사이즈를
ALTER DATABASE DBNAME SET RECOVERY FULL
BACKUP DATABASE DBNAME TO DISK='d:\BDBNAME_FULL.BAK' WITH INIT
'SQL SERVER' 카테고리의 다른 글
| 전체Table Size 확인 (0) | 2022.11.08 |
|---|---|
| SQL 실행횟수 모니터링 (0) | 2022.03.15 |
| Lock Or Expired된 계정 찾기 (0) | 2021.11.25 |
| Examine IO subsystem latencies IN SQL SERVER (0) | 2021.11.24 |
| SQL Server wait Statistics (0) | 2021.11.23 |
2021. 11. 25. 16:45
SQL SERVER
SELECT ServerName = @@SERVERNAME
, LoginName = sp.name
, LockoutTime = LOGINPROPERTY(sp.name, 'LockoutTime')
, IsLocked = LOGINPROPERTY(sp.name, 'IsLocked')
, BadPasswordCount = LOGINPROPERTY(sp.name, 'BadPasswordCount')
, DaysUntilExpiration = LOGINPROPERTY(sp.name, 'DaysUntilExpiration')
FROM master.sys.server_principals sp
WHERE (
LOGINPROPERTY(sp.name, 'IsLocked') = 1
OR LOGINPROPERTY(sp.name, 'BadPasswordCount') > 0
OR LOGINPROPERTY(sp.name, 'DaysUntilExpiration') < 5
)
AND sp.type_desc = N'SQL_LOGIN'
ORDER BY sp.name;
'SQL SERVER' 카테고리의 다른 글
| SQL 실행횟수 모니터링 (0) | 2022.03.15 |
|---|---|
| DB 이관시 설정상태 체크, 변경 (0) | 2022.02.07 |
| Examine IO subsystem latencies IN SQL SERVER (0) | 2021.11.24 |
| SQL Server wait Statistics (0) | 2021.11.23 |
| linked server Disable하기 (0) | 2021.10.21 |