Backup SQL Server 2016 Databases using Powershell
It is possible with SQL Server 2016 (possibly earlier as well) to use Powershell to backup your databases. If I ever need to do this I use the SQL Management console, however I’m using a Mac through RDP which means right click is not working :)
It’s very easy to take the backup, set the variables, of server name, db name and output path.
| $server = “TWSQL1”$database = “ConfigMgr”$output = “C:\Users\Administrator\Desktop\SQL\ConfigMgr.bat” Backup-SqlDatabase -ServerInstance $server -Database $database -BackupFile $output |
So, that’s all in this blog. I will meet you soon with next stuff .Have a nice day !!!
Recommended contents
- MYSQL Port
- Cluster Installation failed with error “Wait on the Database Engine recovery handle failed
- Backup SQL Server 2016 Databases using Powershell
- How to silently install SQL Server 2016 Standard
- How to Resolve SQL Database Error 8959
- Why table can have only one clustered index? No it is not what you think
- Starting with SQL Server
- How to install SQL Server 2017
Guys please don’t forget to like and share the post.Also join our WindowsTechno Community and where you can post your queries/doubts and our experts will address them .
You can also share the feedback on below windows techno email id.
If you have any questions feel free to contact us on admin@windowstechno.com also follow us on facebook@windowstechno to get updates about new blog posts.
