Usage of SHUTDOWN command

SHUTDOWN will switch off an instance of SQL Server without performing checkpoints in all databases.This command will end all user processes and finally closes SQL Server. When SQL Server restarts, it rollbacks all uncompleted transactions. Syntax: SHUTDOWN [ WITH NOWAIT ] You must be a user having either sysadmin or serveradmin fixed server roles to issue SHUTDOWN command.
Ebook Download
View all
Learn
View all