What is a torn page in SQL Server ?
Tuesday, June 5, 2012
Data pages are 8 kilobytes (KB) in size, but SQL Server divides a page into 16 blocks of 512 bytes apiece when performing write operations. If SQL Server begins writing blocks on a page and the disk system fails in the middle of the write process, only a portion of the page is written successfully, producing a problem called a torn page.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningHow will you track and log damaged pages ?
by enabling the PAGE_VERIFY CHECKSUM option.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningWhat is the purpose of the transaction log?
Sunday, June 3, 2012
The transaction log records every change that occurs within a database to persist all transactions to disk.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningWhat are the types of files that you create for databases and what are the commonly used
You can create data and log files for a database. Data files commonly have either an .mdf or .ndf extension, whereas log files have an .ldf extension
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningWhat is Check pointing in SQL Server ?
If you are adding new data to a database, the new data is first written to a memory buffer, then written to the transaction log, and finally persisted to a data file via a background process called check pointing.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningWhat are the various types of backups in sql server ?
Wednesday, May 16, 2012
1•Full backups 2•Differential backups 3•File backups 4•Filegroup backups 5.Partial backups 6•Copy-Only backups 7•Mirror backups 8•Transaction log backups
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Subscribe to:
Posts (Atom)
