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 2005 Forums
 SQL Server Administration (2005)
 Backup example

Author  Topic 

richieasir
Starting Member

13 Posts

Posted - 2010-04-23 : 02:50:06
Hi All,

I have taken a sample database backup. it it successful and the following is the result,

Processed 160 pages for database 'Backup_Sample_DB', file 'Primary1' on file 1.
Processed 8 pages for database 'Backup_Sample_DB', file 'Primary2' on file 1.
Processed 8 pages for database 'Backup_Sample_DB', file 'FG1_File1' on file 1.
Processed 16 pages for database 'Backup_Sample_DB', file 'FG1_File2' on file 1.
Processed 8 pages for database 'Backup_Sample_DB', file 'FG2_File1' on file 1.
Processed 16 pages for database 'Backup_Sample_DB', file 'FG2_File2' on file 1.
Processed 1 pages for database 'Backup_Sample_DB', file 'Log_File1' on file 1.
Processed 0 pages for database 'Backup_Sample_DB', file 'Log_File2' on file 1.
BACKUP DATABASE successfully processed 217 pages in 0.338 seconds (5.015 MB/sec).

I am not able to get what is pages and it is also showing different numbers for each file, can anyone explain me it in detail.May i know the basic concept behind this?


Thank you
Richards

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-23 : 03:21:00
A page is the basic unit of I/O for SQL Server operations.

See here for example (storage):
http://en.wikipedia.org/wiki/Microsoft_SQL_Server


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -