SQLPS Powershell in SQL Server -4

Lets see some more cmdlets

first we need to check examples how to use Backup_Sqldatabase

Run this command
Get-Help Backup-Sqldatabase -Examples

It will give us examples
Similarly for all cmdlets we can get examples how to use it.

Now we will run a sample how take backup

Backup-Sqldatabase -Database Test

It will take backup of Database Test.

How to redirect  result to HTML page?

Run this command

 Invoke-Sqlcmd "select * from sys.tables" | ConvertTo-Html > c:\test.html

Lets see the result in browser by opening test.html in browser.

1 comment:

Post a Comment

Popular Posts