What are the types of backup and tell me the difference
between full and differential backup?
- 4 Answers
- 11995 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
How to generate create procedure script on an existing stored procedure?
What type of locking occurs during the snapshot generation? : sql server replication
How extra digits are handled with numeric data type literals?
explain extended properties
Explain cursor as data base object?
Is null in sql server?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is the difference between getdate and sysdatetime?
Describe in brief system database.
How to create a view using data from another view?
What is normalization according to you and explain its different levels?
Explain trigger and its types?
How to perform key word search in tables?
How network traffic be reduced by using the stored procedure?
List out a number of the wants to setup a SQL Server failover cluster?
