February 12, 2014 at 4:27 am
Can anyone help me with links where in i will be able to pass down the documents to junior members..
1) Full Backup
2) Differential Backup
3) Log Backup..
A Junior DBA must set a Full backup following with Diferentail & log backups..
Now incase any table gets dropped or data deletion.. DBA should restore all possible backup & provide missing data if it can be recovered..
Can anyone share a scenario with queries?? also help with tail-log backup procedure.
************************************
Every Dog has a Tail !!!!! :-D
February 12, 2014 at 7:54 am
Some links:
http://www.sqlservercentral.com/Forums/Topic1220236-1550-1.aspx
http://thefirstsql.com/2012/05/29/updated-create-point-in-time-restore-script-automatically/
http://technet.microsoft.com/en-us/library/ms179451.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 9:00 am
Here's an article[/url] I wrote on doing backups that includes new material from SQL Server 2014. It covers all the basics. This is an older article[/url] I wrote on the same topic for SQL Server 2005. I don't think it covers the material as well. And this is an article[/url] I wrote around the concepts of the SQL Server backup for the accidental DBA. That pretty much qualifies as a junior DBA too.
"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
February 13, 2014 at 1:39 am
Great Thanks... 🙂
Does any one know about the Interview questions for DBA?
Like what is DB is corrupt then how to recover it etc... such type of questions & answers...
************************************
Every Dog has a Tail !!!!! :-D
February 13, 2014 at 3:55 am
There are lots of blog posts on DBA interview questions. Just do a search for them.
"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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply