I dont know to what extent it can be automated with powershell i do know that if you google for help and advice on getting things done in ms sql server, you get voksen nettsteder anmeldelser troms a lot of people saying right-click on your database, then click on tasks.