<div>
<div class="content wysiwyg-content">
Within PowerShell, is the SMO.Settings.BackupDirecto<wbr />ry a read-write property. If it can be written to, does that affect the value that has been stored for the database server, or is it just for that invocation of the object?<br />
<br />
I am using the Microsoft.SqlServer.Manage<wbr />ment.Smo.S<wbr />erver object to perform a backup of the database before running the script. The client does not want the backup stored in the default folder. If changing this setting changes it for the database, then I will need to retrieve the current value and save it, perform the backup, then set it back to the original value, so I need to know the scope involved if I change the value.
</div>
</div>


Within PowerShell, is the SMO.Settings.BackupDirectory a read-write property. If it can be written to, does that affect the value that has been stored for the database server, or is it just for that invocation of the object?

I am using the Microsoft.SqlServer.Management.Smo.Server object to perform a backup of the database before running the script. The client does not want the backup stored in the default folder. If changing this setting changes it for the database, then I will need to retrieve the current value and save it, perform the backup, then set it back to the original value, so I need to know the scope involved if I change the value.

PowerShell with SQL Server SMO BackupDirectory

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.