Skip to content

Instantly share code, notes, and snippets.

@kashiash

kashiash/script.sql

Last active March 8, 2022 19:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kashiash/c412c958afce3e2872cd2e9d11fe73a5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kashiash/c412c958afce3e2872cd2e9d11fe73a5 to your computer and use it in GitHub Desktop.
Download ZIP
#SQL #uta #truncate #log file #ulubione
Raw
script.sql
use timex8_I
ALTER DATABASE Timex8_I SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(Timex8_I_log, 1) --,truncateonly)
ALTER DATABASE Timex8_I SET RECOVERY FULL WITH NO_WAIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment