We're having to do an emergency migration of all of our MSSQL databases from a dying box to a new shiny instance of SQL2008. Unfortunately, we're having to do it by restoring from nightly backups (.bak files).
Is there a way of:
- Automating the restore of a batch of files so as to go:
- DatabaseName.bak >[restore to]> DatabaseName
- Automating the removal of a specific user from the DB's security>users list?
Yell if you need more information