USE master
EXEC sp_configure ‘show advanced options’, 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure ‘max server memory (MB)’, 4096
RECONFIGURE WITH OVERRIDE
EXEC sp_configure ‘show advanced options’, 0
RECONFIGURE WITH OVERRIDE
Tag: SQL
Create MS SQL database backup
CREATE DATABASE my_backup_db ON ( NAME = my_db, FILENAME = 'c:\mybakup.bak' ) AS SNAPSHOT OF my_production_db