Category: MSSQL

SQL Server Management Studio 실행 – 새 쿼리 방법 1) select @@version; 방법 2) SELECT ‘SQL Server ‘+ CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR) + ‘ – ‘+ CAST(SERVERPROPERTY(‘productlevel’) AS VARCHAR) + ‘ (‘+ CAST(SERVERPROPERTY(‘edition’) AS VARCHAR) + ‘)’ F5 누르기 ; 쿼리 실행

1. 개요 MSSQL Express 버전은 백업 스케쥴러가 없어서 스크립트로 백업해야한다.   2. SQL문 작성 — Format — DECLARE @DIR NVARCHAR(100) DECLARE @BACKUPNAME NVARCHAR(100) SET @DIR = N'[폴더명]\[파일명]_’ + CONVERT(NVARCHAR(20), GETDATE(), 112) + N’.BAK’ SET @BACKUPNAME = N'[폴더명]\[파일명]_’ + CONVERT(NVARCHAR(20), GETDATE(),112) + N’.BAK’ BACKUP DATABASE [DB] TO DISK = @DIR WITH NOFORMAT, NOINIT, NAME = @BACKUPNAME, […]

1. MSSQL 메모리 할당량 확인 SELECT (physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB, (locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB, (total_virtual_address_space_kb/1024) AS Total_VAS_in_MB, process_physical_memory_low, process_virtual_memory_low FROM sys.dm_os_process_memory;