A newbie to SQL server

Question

Post reply

A newbie to SQL server

glen_malcolm

Grasshopper

Points: 22
More actions
April 18, 2016 at 8:46 am

#313310

Hello guys and gals.
A newbie to SQL & trying to learn the ropes without hanging myself. Been searching online to find a proper/definitive document on the different types of backup (mainly for SQL 2012) Can any of you wise gurus help me. Thanks in advance.
GM

Viewing 10 posts - 1 through 9 (of 9 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

This should do the job

http://www.sqlservercentral.com/articles/books/89519/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

glen_malcolm Grasshopper Points: 22 More actions · Answer 2

glen_malcolm

Grasshopper

Points: 22

April 18, 2016 at 9:09 am

#1872793

Thanks Gila, much appreciated. 🙂

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

And here's a quicker read, an article on getting started with backups[/url]. And restores.

"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

glen_malcolm Grasshopper Points: 22 More actions · Answer 4

Grant Fritchey (4/18/2016)
And here's a quicker read, an article on getting started with backups[/url]. And restores.

That is fantastic, I shall be reading that in detail over the next few hours and will try it out in a test environment too. 🙂

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 5

Check this out as well:

https://www.brentozar.com/archive/2013/07/announcing-our-free-accidental-dba-6-month-training-plan/

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 6

glen_malcolm (4/19/2016)
Grant Fritchey (4/18/2016)
And here's a quicker read, an article on getting started with backups[/url]. And restores.
That is fantastic, I shall be reading that in detail over the next few hours and will try it out in a test environment too. 🙂

I hope it's helpful. There's also this one.[/url]

"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

glen_malcolm Grasshopper Points: 22 More actions · Answer 7

Thanks all of you for your input and advice, next trick is to find out and to learn restore processes...

Ricky Valencia SSCommitted Points: 1907 More actions · Answer 8

Hi

You might also want to check out the Microsoft Virtual Academy Training link below.

https://mva.microsoft.com/en-US/training-courses/designing-database-solutions-for-sql-server-8484?l=HN0uqzXz_3704984382

Watch the video on "Designing a Backup Recovery Solution for SQL Server"

I hope this helps.

Thanks

Best Regards,

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

glen_malcolm (4/19/2016)
Thanks all of you for your input and advice, next trick is to find out and to learn restore processes...

The book I linked should have restore details as well.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass