Plz tell about backup&recovery?

Answers were Sorted based on User's Feedback



Plz tell about backup&recovery?..

Answer / kanan

Mirrored backups

SQL Server 2005 lets you create mirrored backups. A mirrored
backup allows you to create two or four identical copies of
the backup files in case one of the sets is damaged.

Is This Answer Correct ?    0 Yes 0 No

Plz tell about backup&recovery?..

Answer / senthilsjc

Hai hari...
Thnaks for ur answere..but

Don't post answer what u read in material

b'coz all are know backup type & recovery type
if u post answer its wanna most use full others
that's y i am asking..
this is my humble request..
don't mind..

carry onn..

Is This Answer Correct ?    1 Yes 3 No

Plz tell about backup&recovery?..

Answer / hari

Back up is 3 types
Full backup
Differential backup
Transcational log backup

Recovery
simple recovery
full recovery
Bulk recovery

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  


What are filegroups in sql server?

0 Answers  


what is database replication? : Sql server database administration

0 Answers  


What is the difference between having clause and where clause in sql server?

0 Answers  


What are different types of views?

0 Answers  






What is index?

1 Answers   Cap Gemini,


What are the transaction properties?

0 Answers  


If a table does not have a unique index, can a cursor be opened on it?

0 Answers  


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  


What are the different type of replication in sql server?

0 Answers  


What are the types of user defined functions in sql server?

0 Answers  


How to get a list all databases on the sql server?

0 Answers  


Categories