Plz tell about backup&recovery?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the query of a table in sql server?

504


What is a partitioned view?

576


Can you type more than one query in the query editor screen at the same time?

578


Which tcp/ip port does the sql server run on? How can it be changed?

531


If any stored procedure is encrypted, then can we see its definition in activity monitor?

551






Does a full backup include transaction log?

485


What is the difference between a view and a stored procedure?

565


Why union all is faster than union?

510


Tell me in brief how sql server enhances scalability of the database system?

536


How to use subqueries in the from clause in ms sql server?

571


What is difference between Datepart() and Datename() in SqlServer?

724


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

505


Define normalisation?

678


How the authentication mode can be changed?

610


What is Transparent Data Encryption?

591