Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Hi..here i would like to know the Backup and Restore models?

Question Posted / durga prasad

Answers were Sorted based on User's Feedback



Hi..here i would like to know the Backup and Restore models?..

Answer / naren

Back up we have full and defferential
(incremental),transaction log backups


Recovery models full,bulk, simple

Is This Answer Correct ?    6 Yes 0 No

Hi..here i would like to know the Backup and Restore models?..

Answer / laxman

that may recovery models:
simple
bulk-loged
full

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How do I clean up sql server transaction log?

0 Answers  

what is a transaction? : Sql server database administration

0 Answers  

What is 4nf in normalization form?

0 Answers  

Does a server store data?

0 Answers  

Why normalization is used?

0 Answers  




What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

Describe about first three Normal forms.

1 Answers   HP,

What is use of @@ spid in sql server?

0 Answers  

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

Can truncate be rolled back?

0 Answers  

What is table valued function and scalar valued functions?

0 Answers  

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

For more SQL Server Interview Questions Click Here
Categories