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 |
When multiple after triggers are attached to sql table, how to control the order of execution?
Explain Geography datatype in SQL Server
What are the steps to process a single select statement?
Can you tell me about the concept of ER diagrams?
what protocol both networks use? : Sql server database administration
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
What is public role in sql server?
What are commonly used mssql functions in php?
what is replication? where do u use Go Keyword?
How can sql server instances be hidden? : sql server security
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How create table structure only from tableA to TableB if TableA have some data?
Oracle (3253)
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)