5

Is it possible to batch restore backups and remove users from databases in MSSQL 2008?

view full story
linux-howto

http://serverfault.com – 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 (HowTos)