Summary: Use Windows PowerShell to back up system databases. How can I use Windows PowerShell to dynamically back up all of the system databases on my servers? Combining provider lookups with the Backup-SqlDatabase cmdlet makes this simple: $instances = @(‘KIRK’,’SPOCK’,’PICARD’,’RIKER’) ...
Summary: Guest blogger, Mike Fal, talks about leveraging the SQL Server PowerShell provider. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Mike Fal. He blogged yesterday (see Getting Information from the SQL Server Provider with PowerShell), and he continues today... In my previous post, I covered how to gather and view ...
Summary: Use Windows PowerShell to find versions of SQL Server. How can I use Windows PowerShell to see all the versions of SQL Server I have installed? Use the provider and a list of instances to look them up as if they were files in a directory:$instances = @(‘KIRK’,’SPOCK’,’PICARD’,’RIKER&rsquo...
Summary: Guest blogger, Mike Fal, talks about using the SQL Server provider with Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. We have a new guest blogger today. Please welcome Mike Fal. Mike Fal. Mike has over 15 years of experience as a database administrator. He has worked for many different industries, including healthcare, ...
