Lets see some more cmdlets
1.Backup-Sqldatabase
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.Backup-Sqldatabase
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:
Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..have a peek at this site school branding uk
Post a Comment