Force a SQL Restore

Really tired of having to google this and piece it together every time I want it, so I’m posting it here.

alter database DbName
    set single_user
    with rollback immediate
go

restore database DbName
    from disk = 'path/to/backup.bak'
    with file = 1, replace

Notables:

  • Works best to run against the master database.
  • The file = 1 part may need to be changed if there are multiple backups in the file and the one you want isn’t the first one.
This entry was posted in CodeMinder, SQL. Bookmark the permalink.