• 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

RECENT POST
Please reload

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