Plz tell about backup&recovery?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Tell me what is de-normalization and what are some of the examples of it?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Explain unique key in sql server?
What are mdf,ndf,ldf files and how to see the data in those files?
Can you link only other SQL Servers or any database servers such as Oracle?
What is de-normalization and when do you do it?
What do you understand by physical_only option in dbcc checkdb?
What are the types of constraints?
what is checksum in sql server.........???
Explain various data region available in ssrs with their use?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)