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

Plz tell about backup&recovery?

Question Posted / senthilsjc

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

How secure is sql server database?

0 Answers  

Explain magic tables in sql server?

0 Answers  

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

How to encrypt data between dialogs?

0 Answers  

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  




What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

Explain the types of indexes.

0 Answers   Accenture,

Describe the functionalities that views support.

0 Answers  

Define Unique Key?

0 Answers   HCL,

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

What are the OS services that the SQL Server installation adds?

3 Answers  

What does it mean to invest in the index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories