Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/Backup whole db without detaching (MSSQL Server)

Created January 13, 2020 18:58
Show Gist options
  • Save arekgotfryd/d0a08db6ee9115e51d8a70a3a9a2da63 to your computer and use it in GitHub Desktop.
Save arekgotfryd/d0a08db6ee9115e51d8a70a3a9a2da63 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Backup whole db without detaching (MSSQL Server)
BACKUP DATABASE VI_GenericRetail TO DISK = 'C:\exports\VI_GenericRetail.bak'
WITH COPY_ONLY, INIT, NO_COMPRESSION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment