Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nishita_s
Yak Posting Veteran
61 Posts |
 Posted - 2008-12-31 : 03:43:39
|
| What steps SQL Server follow to when we take Full Backup?? |
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2008-12-31 : 03:46:53
|
| A full backup (formerly known as a database backup) backs up the entire database, including part of the transaction log (so that the full backup can be recovered). Full backups represent the database at the time the backup completed. The transaction log included in the full backup allows it to be used to recover the database to the point in time at which the backup was completed. Creating a full backup is a single operation, usually scheduled to occur at regular intervals. |
 |
|
|
nishita_s
Yak Posting Veteran
61 Posts |
Posted - 2008-12-31 : 03:50:22
|
| Actually i want steps which SQL server takes when we start taking full backup. like it first locks database then keep mark in transaction log and all other steps. |
|
|
|
|
|
|
Query related to Full Backup