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.

Comments !

links

social