Query to take the backup

Question

Post reply

Query to take the backup

ramyours2003

SSChampion

Points: 12268
More actions
February 2, 2017 at 7:50 am

#318266

I need a query to take the differential backup of all the databases in sql ? can any one help ..
Thanks,
February 5, 2017 at 10:09 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 1

I love to help people help themselves, so here you go:

http://lmgtfy.com/?q=take+the+differential+backup+of+all+the+databases+in+sql

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

NicHopper SSCrazy Eights Points: 9090 More actions · Answer 2

Hi,

This should help you out;

https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases

To do Diff backups you'll first need a full backup, so you can just modify the sample to do a diff backup rather than full

Any problems then let me know.

Thanks,

Nici

Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

Jeff Moden SSC Guru Points: 1004374 More actions · Answer 3

ramyours2003 - Thursday, February 2, 2017 7:50 AM
I need a query to take the differential backup of all the databases in sql ? can any one help ..
Thanks,

Yes, You can. It sounds like you're "in charge" of backing up databases, which is a very serious requirement for whatever company you work for and it sounds like you don't know anything about it. You seriously need to hit the books on this subject or you'll be in deep Kimchee when a database goes corrupt. You need to study how to not only do backups but how to do restores and practice both until you can do both in your sleep.

Kevn3nf actually demonstrated how to start your training on this. This isn't something to fart around with. You have to learn it and learn it very well so that when something goes wrong with someone else's script, you'll know how to fix it. Do it for your self and for the company that's giving you a paycheck to feed your family. This is the very first thing that anyone responsible for data should learn. Do it now.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 4

I did a video on Backup Basics awhile back:

https://www.youtube.com/watch?v=6Uv_O8l7KRs

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Fernando Jacinto Alvarez SSC Veteran Points: 275 More actions · Answer 5

you can use Olla Hallengren maintenance solution not just for backups https://ola.hallengren.com/sql-server-backup.html