DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans

  Рет қаралды 16,717

Brent Ozar Unlimited

Brent Ozar Unlimited

Күн бұрын

Пікірлер: 31
@AdrianAska-y5i
@AdrianAska-y5i Жыл бұрын
This guy is great for my low attention span. Thank you so much!
@BrentOzarUnlimited
@BrentOzarUnlimited Жыл бұрын
You're welcome!
@GeraldOSullivan
@GeraldOSullivan 6 ай бұрын
Excellent. Nice combination of good advice and practicality. Good work!
@BrentOzarUnlimited
@BrentOzarUnlimited 6 ай бұрын
Glad you enjoyed it!
@jasonliang9114
@jasonliang9114 2 жыл бұрын
Wonderfully explained. Thanks for the explanation.
@rutwik_1200
@rutwik_1200 20 күн бұрын
Basic SQL version don't have maintance plan? I don't see maintainace plan option in management section
@Mohammed-yj1zt
@Mohammed-yj1zt 2 ай бұрын
when we should use SQL Agent and when Maintenance plans? I'm confuse because of I heard someone says sql agent better than maintenance and he moved to it instead of the maintenance
@BrentOzarUnlimited
@BrentOzarUnlimited 2 ай бұрын
The person who told you Agent jobs are different than maintanence plans didn't do a good job of explaining. Agent is the thing that handles scheduling. Agent calls maintenance plans AND scripts.
@Mohammed-yj1zt
@Mohammed-yj1zt 2 ай бұрын
@@BrentOzarUnlimited thank you so much
@YvdB
@YvdB Ай бұрын
Can I asume that the azure edition works the same as enterprise edition?
@BrentOzarUnlimited
@BrentOzarUnlimited Ай бұрын
No, I have a separate class for Running SQL Server in Azure & AWS.
@UB764
@UB764 2 жыл бұрын
Legend
@Ренат-ц8ж
@Ренат-ц8ж 2 жыл бұрын
Thank you!
@steveabba8463
@steveabba8463 3 жыл бұрын
Thanks Brent!!!
@haazimali489
@haazimali489 11 ай бұрын
You cover setting up full database backups and log backups but don't mention differential backups. Why?
@BrentOzarUnlimited
@BrentOzarUnlimited 11 ай бұрын
Because I can't cover every topic in every video. ;-)
@reyamcarias8202
@reyamcarias8202 3 жыл бұрын
Thanks brent
@TheMistervac
@TheMistervac Жыл бұрын
Good basic guide. At 6:24 you said you didn't like to back up to a local drive and move it to a drive off the server. Yes, I agree, but this way is a bit risky. Why ? I explain with my example. I made backups directly to NAS QNAP and ZYXEL connected to the server using the iSCSI protocol. There were times when the NAS disconnected for various reasons. Then there was a problem with the lack of backup. Personally, I do it as you show, but first on a local drive. If the backup is completed correctly, the next step is to call Execute SQL Server Agent Job Task and in it call the created Jobs with the command (Operating system CmdExec) xcopy /S /C /V /Y D:\BACKUP F:\BACKUP where D: local disk of the server and QNAP mapped as F. I have one more of the same task but I am copying the backup to ZYXEL. In the e-mail notification, I have set that in case of problems with backup, cleaning old files or copying, I get an e-mail. Then I check what the problem is. This way I always have at least one good backup. Plus, I do a SNAP every few hours. All the best.
@BrentOzarUnlimited
@BrentOzarUnlimited Жыл бұрын
I didn't say iSCSI: I said network shares.
@TheMistervac
@TheMistervac Жыл бұрын
@@BrentOzarUnlimited Ok, I also have a Xtreamer e-TRAYz NAS connected via SMB. This one disappears quite often, so it's not credible to me. So, I prefer local disk first and then NAS.
@BrentOzarUnlimited
@BrentOzarUnlimited Жыл бұрын
@@TheMistervac Given that SQL Server Standard Edition costs $2,000 USD per CPU core, most folks use something more reliable. You're not pirating SQL Server, are you?
@TheMistervac
@TheMistervac Жыл бұрын
@@BrentOzarUnlimited I only use licensed software. 😀SQL standard is for 2 cores.
@BrentOzarUnlimited
@BrentOzarUnlimited Жыл бұрын
@@TheMistervac Incorrect: the minimum number of cores for licensing is 4. They're sold in 2-packs only so that you can use, say, 6 cores. Read the Microsoft SQL Server licensing guide.
@CodeXploit
@CodeXploit 3 жыл бұрын
Hallengreen or bust...
@162900443
@162900443 3 жыл бұрын
Hmmm... who is bust?
@CodeXploit
@CodeXploit 3 жыл бұрын
@@162900443 Anyone who is not using Halengreen 😉
@YvdB
@YvdB Ай бұрын
In europe we take 3 week holidays. Should we keep 4 weeks of backups?
@BrentOzarUnlimited
@BrentOzarUnlimited Ай бұрын
For customized answers based on your own production scenarios, feel free to contact me for consulting.
@lucianavasiloiei7864
@lucianavasiloiei7864 2 жыл бұрын
Thank you!
@BrentOzarUnlimited
@BrentOzarUnlimited 2 жыл бұрын
You're welcome!
DBA Fundamentals - Backups 4: Setting Up Ola Hallengren's Scripts for Backups
33:52
DBA Fundamentals: Maintenance: Agent Jobs
12:22
Brent Ozar Unlimited
Рет қаралды 6 М.
Бенчик, пора купаться! 🛁 #бенчик #арти #симбочка
00:34
Симбочка Пимпочка
Рет қаралды 4 МЛН
ROSÉ & Bruno Mars - APT. (Official Music Video)
02:54
ROSÉ
Рет қаралды 204 МЛН
Миллионер | 2 - серия
16:04
Million Show
Рет қаралды 1,8 МЛН
DBA Fundamentals: Maintenance: Shrinking Files
15:21
Brent Ozar Unlimited
Рет қаралды 16 М.
DBA Fundamentals: Corruption: Checking for Corruption
40:52
Brent Ozar Unlimited
Рет қаралды 10 М.
What To Do When SQL Server is Slow   Brent Ozar
58:50
DBAFundamentals
Рет қаралды 41 М.
Deadlocks: Lets Do One, Understand It, and Fix It
44:01
SQLBits
Рет қаралды 37 М.
Backups 1: 3 Common Strategies
41:57
Brent Ozar Unlimited
Рет қаралды 35 М.
Senior DBA Class - Index Maintenance for Enterprise Environments
43:02
Brent Ozar Unlimited
Рет қаралды 13 М.
DBA Fundamentals: Patching SQL Server
23:26
Brent Ozar Unlimited
Рет қаралды 14 М.
Fragmentation Explained in 20 Minutes
18:40
SQLBits
Рет қаралды 14 М.
DBA Fundamentals: Backups 2: Restores
38:00
Brent Ozar Unlimited
Рет қаралды 13 М.