Skip to content

Releases: AnsCodeLab/SsmsQuickRestore

v1.1.1

30 Apr 06:14

Choose a tag to compare

  • Rebrand author to AnsCodeLab

v1.1.0

29 Apr 07:53

Choose a tag to compare

  • Updated author name to Anson Nguyen

v1.0.0 - Initial release

19 Apr 08:06

Choose a tag to compare

SSMS Quick Restore v1.0.0

One-click database restore for SQL Server Management Studio 21 and 22 from .bak/.trn files.

Install

Recommended: download SsmsQuickRestore-Setup-1.0.0.exe, run it as Administrator. The installer:

  • Auto-detects SSMS 22/21 install paths (default location + registry fallback)
  • Refuses to install if SSMS isn't found and offers a download link
  • Installs to <SSMS>\Common7\IDE\Extensions\SsmsQuickRestore\
  • Runs Ssms.exe /updateconfiguration to refresh the SSMS pkgdef cache
  • Adds an Add/Remove Programs entry for clean uninstall

Manual: download SsmsRestoreDrop.vsix, follow the steps in README.md.

Features

  • Toolbar button + Tools -> Restore from backup file... menu item
  • Drag-and-drop .bak / .trn onto the SSMS window
  • Embedded output pane shows generated T-SQL (Script button) or live progress log (Restore button), with Copy / Clear buttons
  • Server connection from active Object Explorer node, or ad-hoc Connect dialog (Windows / SQL auth)
  • Backup-set picker (RESTORE HEADERONLY) and auto-filled file relocation grid (RESTORE FILELISTONLY)
  • Options: REPLACE (default), NORECOVERY, STANDBY, KEEP_CDC, close existing connections, take tail-log backup
  • After successful restore: choose Yes to close the dialog or No to keep it open and review the log
  • Auto-loads on SSMS shell init so drag-drop works on first launch
  • Dual logging: SSMS Output window pane + rolling file at %APPDATA%\SsmsQuickRestore\Logs\

Requirements

  • SSMS 21 or 22
  • .NET Framework 4.8 (ships with SSMS)
  • Windows 10 / 11