• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

Backup All Users databases via Select and Cursor!

December 20, 2016

In this articlke we are going to focus on:


How to back up all user databases using one script?


One day at work I dealt with Sharepoint, I needed to install new updates. So, I needed to do backup of all Sharepoint databases, therefore I had to

come up with some script which would be able backup all databases.


We can use SELECT Statement for generating query, as you can see below:


 Then copy the query and run backup!


Or, we can use my favorite CURSOR, the query is the following:



I hope that this short article helps you out!




Please reload

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon