PowerShell, gives us power to do task very quickly just by writing few line of magical scripts.
Today was looking to create backup of SQL database with the help of Windows Powershell and believe me it's too easy and fast.
So let's start,
$Server = '<Server_Name>'
$Database = '<Database_Name>'
$FilePath = '<TargetPath/Backup_FileName.bak>'
Backup-SqlDatabase -ServerInstance $Server -Database $Database -BackupFile $FilePath
for source code please click here
For example:
$Server = 'SQLServer'
$Database = 'POCDatabase'
$FilePath = 'C:\POCDatabase.bak'
Backup-SqlDatabase -ServerInstance $Server -Database $Database -BackupFile $FilePath
That's it, now check the backup file at target path.
@Note Sometime Backup-SqlDatabase commands not exist, then in this case have to manually add module to the PowerShell related to SQL by
Import-Module SQLPS
after importing module again try the above scripts.
Today was looking to create backup of SQL database with the help of Windows Powershell and believe me it's too easy and fast.
So let's start,
$Server = '<Server_Name>'
$Database = '<Database_Name>'
$FilePath = '<TargetPath/Backup_FileName.bak>'
Backup-SqlDatabase -ServerInstance $Server -Database $Database -BackupFile $FilePath
for source code please click here
For example:
$Server = 'SQLServer'
$Database = 'POCDatabase'
$FilePath = 'C:\POCDatabase.bak'
Backup-SqlDatabase -ServerInstance $Server -Database $Database -BackupFile $FilePath
That's it, now check the backup file at target path.
@Note Sometime Backup-SqlDatabase commands not exist, then in this case have to manually add module to the PowerShell related to SQL by
Import-Module SQLPS
after importing module again try the above scripts.
No comments:
Post a Comment