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 |
What is @@Identity in sql?
What are the dis_advantages of stored procedures, triggers, indexes?
Can I work with several databases simultaneously? : sql server management studio
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
Explain different backup plans?
Where are full-text indexes stored?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What are the purpose of Normalisation?
What are different types of join?
Why truncate is ddl command?
What are a database and a data warehouse?
Does full backup break log chain?
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)