May 7, 2019 at 9:34 am
Hello everyone,
I am New in this Forum and in SQL Server,
i will glad for your Help for a little quastion:
I want to create a job, that execute Backup for five database, every day in certain time.
How do i create the jobs?
thanks!
May 7, 2019 at 9:41 am
May 7, 2019 at 10:21 am
What you're after here is SQL Server Agent. The documentation will likely tell you everything you need to know. I suggest having a read and a go yourself first, you'll learn more than way. If you get stuck, or things aren't working as you expect, then reply letting us know what you've done, include any SQL you've written and screenshots of your agent job and explain why didn't work.
Good luck!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 11:08 am
Also, look up Ola Hollengren's scripts for backups. They'll serve you well.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply