Answer / samba shiva reddy . m

When restoring a SQL Server Database, I notice that there are 3 different Recovery States to choose from:

Restore with Recovery
Restore with No Recovery
Restore with Standby

NORECOVERY

Instructs the restore operation to not roll back any uncommitted transactions. Either the NORECOVERY or STANDBY option must be specified if another transaction log has to be applied. If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the default.

SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or when multiple RESTORE statements are needed (for example, a full database backup followed by a differential database backup).

Note When specifying the NORECOVERY option, the database is not usable in this intermediate, nonrecovered state.

When used with a file or filegroup restore operation, NORECOVERY forces the database to remain in the restoring state after the restore operation. This is useful in either of these situations:

A restore script is being run and the log is always being applied.

A sequence of file restores is used and the database is not intended to be usable between two of the restore operations.

STANDBY = undofilename

Specifies the undo file name so the recovery effects can be undone. The size required for the undo file depends on the volume of undo actions resulting from uncommitted transactions. If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the default.

STANDBY allows a database to be brought up for read-only access between transaction log restores and can be used with either warm standby server situations or special recovery situations in which it is useful to inspect the database between log restores.

If the specified undo file name does not exist, SQL Server creates it. If the file does exist, SQL Server overwrites it.

The same undo file can be used for consecutive restores of the same database. For more information, see Using Standby Servers.

Important If free disk space is exhausted on the drive containing the specified undo file name, the restore operation stops.

STANDBY is not allowed when a database upgrade is necessary.

Answer / guest

in standby mode the database exists to access for readonly
purpose
we can use the database for read only we can not able to
modify

in no recovery mode the database is not accessible

Working with TLogs

0 Answers  

---

What is dbcc? Give few examples.

0 Answers  

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---

What is an expression in ms sql server?

0 Answers  

---

Do you know what are acid properties of transaction?

0 Answers  

---

What do you mean by acid?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

What does truncate do?

0 Answers  

---

what is sql injection?

2 Answers  

---

what is blocking? : Sql server database administration

0 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---