auto answer yes to all or yes in scripts

Reply

Zxarr Posted: 07-27-2007 1:15 PM

rated by 0 users

Greetings,

I am in the middle of moving databases and log files to larger drives.  I know the command to use and it works quite well, but is there a way, in a ps1 script of always answering yes to the confirmation questions?

I'd like to let this script run overnight.

Thanks. 

Reply

Joel Stidley replied on 07-27-2007 5:26 PM

rated by 0 users

You can use the -force switch in the move-databasepath and move-storagegrouppath cmdlets which should suppress prompts.

Reply

Zxarr replied on 07-31-2007 8:05 AM

rated by 0 users

Odd, that seems like it should work.  It didn't.  Here is the command I am using: 

 Move-DatabasePath -Identity nb-ws-sv-0015\b -EdbFilePath N:\DB\b\b.edb -Force

I have tried moving the -Force switch around in the line, to no avail.

Any other ideas out there? 

Reply

bkeane replied on 07-31-2007 9:33 AM

rated by 0 users

In addition to using "the force", also use -Confirm:$false.  This will perform the task without prompting you.

Reply

Zxarr replied on 07-31-2007 9:37 AM

rated by 0 users

Thanks,

I'll try that as soon as this database is finished migrating...  I thought $false may come into play somewhere, but it didn't like it after -Force...

:)