Backup - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Backup

Author

Topic

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-03-10 : 02:27:39

How SQL Server Manage Backup Sequence?

How SQL Server will Take only Modified Data's since the last complete backup?

Is SQL Server Set any archive bit each backup?

--
Ragu Thangavel
Junier Sql Server DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-10 : 02:42:06

Not sure what you mean by sequence.

For full backups, it backs up everything. For diffs and tlogs, it uses lsn's to keep track.

Archive bits are not set for SQL. Tape backup software generally does set it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-03-10 : 02:51:19

Thank you

--
Ragu Thangavel
Junier Sql Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources