What are the types of backup and tell me the difference
between full and differential backup?

Answer Posted / ravi

Full
diffrential
T-log
Tail log
mirrored
copy only
striped
file and file group
Full: taking data , meta data and services of a database
into our os file..both ldf and mdf
diff: it takes only changes occured in the data ofter
taking the full bakup..

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is spatial and temporal data?

543


How to create an inline table-valued function?

540


What is field in algebra?

634


Find columns used in stored procedure?

534


Is it important for a database administrator to understand the operating system and file access?

521






Define Joins?

621


Can we install sql server 2016 on windows 7?

682


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

502


How many cores do I need for sql server 2016?

513


What is co-related sub query?

572


Explain “not null constraint” in sql server?

532


What are the types of containers in ssis?

607


How do I connect to sql server database?

486


What is the purpose of the model database?

607


What are the different types of triggers in SQL SERVER?

546