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
How to change a login name in ms sql server?
What is the contrast between sql and pl/sql?
What number aggregate functions are accessible there in sql?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Can group by and orderby be used together?
What is an execution plan?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What method is used by the Command classes to execute SQL statements that return single values?
How to loop through result set objects using mssql_fetch_array()?
How to insert a new row into a table with "insert into" statements in ms sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Explain sub-query?
Why do we need normalization?
What is the usage of sign function?