SQL server 2016 - Backup definition

Question

SQL server 2016 - Backup definition

guerrerocz87

Old Hand

Points: 348
More actions
November 22, 2017 at 11:50 am

#329630

Hello.
I have SQL server 2016 over a Windows server 2016 on Amazon web service,
I need to set up backup´s from all the database and the server.
For the database i use native backups but i need to define what kind of backup im going to do for the entire Server.
AWS AMI or AWS EBS Snapshot?
regards!

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

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

Evgeny Garaev SSCertifiable Points: 7428 More actions · Answer 1

guerrerocz87 - Wednesday, November 22, 2017 11:50 AM
... i need to define what kind of backup im going to do for the entire Server...

Hi,

That is not SQL Server related question but I can try to help you. Check this article - https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/wbadmin-start-backup

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 2

Be super careful about mixing backups. An Amazon backup might not get you a consistent database one, and you might see suspect databases on system/Windows restore that you need to restore from a full (+diff/log) database backup.

guerrerocz87 Old Hand Points: 348 More actions · Answer 3

Evgeny - Wednesday, November 22, 2017 1:04 PM
guerrerocz87 - Wednesday, November 22, 2017 11:50 AM
... i need to define what kind of backup im going to do for the entire Server...
Hi,
That is not SQL Server related question but I can try to help you. Check this article - https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/wbadmin-start-backup

Thank you for the response.

I put this question here because i donÂ´t know if when i create an AMI on AWS the database get corrupted,

Maybe my question is not well documented, i apologize for that...

I need to define the Disaster Recovery for the SQL environment over Amazon Web Services.

regards!

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 4

guerrerocz87 - Wednesday, November 22, 2017 2:00 PM
Evgeny - Wednesday, November 22, 2017 1:04 PM
guerrerocz87 - Wednesday, November 22, 2017 11:50 AM
... i need to define what kind of backup im going to do for the entire Server...
Hi,
That is not SQL Server related question but I can try to help you. Check this article - https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/wbadmin-start-backup
Thank you for the response.
I put this question here because i donÂ´t know if when i create an AMI on AWS the database get corrupted,
Maybe my question is not well documented, i apologize for that...
I need to define the Disaster Recovery for the SQL environment over Amazon Web Services.
regards!

Ummmm.... I'm not 100% sure but from reading the "pricing" pages for AWS, isn't DR/Backups/Restores supposedly automatically included in the price?

--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)

guerrerocz87 Old Hand Points: 348 More actions · Answer 5

Everything you backup on AWS (snapshot or AMI) have a charge $$

I just want to know if ...
i make a snapshot from the database volumes, (for example disk C or D),
the database works normally after i restored?

In other words...
the database files get corrupteds?

regards!

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 6

If there are transactions in flight, or unflushed changes, your C: or d: restore of database files might not work. SQL Backups work by ensuring that in flight activity is captured for replay or rollback as needed.

guerrerocz87 Old Hand Points: 348 More actions · Answer 7

Steve Jones - SSC Editor - Wednesday, November 22, 2017 4:37 PM
If there are transactions in flight, or unflushed changes, your C: or d: restore of database files might not work. SQL Backups work by ensuring that in flight activity is captured for replay or rollback as needed.

Ok. so..
for the DRP it will be better if i create an AMI for only disk C and the databases will be manually restored over management studio,
Thath will be your recommendation?

regards!