What are the types of backup and tell me the difference
between full and differential backup?
- 4 Answers
- 12337 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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
What is mean by dml?
What is equi join with example?
Do you know what is blocking?
When would you use sql joins?
Which database stores information about replication?
Explain the steps needed to create a scheduled job?
What is difference between rownum and row_number?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How many columns can exist together per table?
What are different types of raid configurations? : SQL Server Architecture
Define model database?
how many no of arguments can be passed in procedures and functions
What do you know about normalization and de- normalization?
What are the restrictions applicable while creating views? : SQL Server Architecture
