5 pts.
 Backup storage for sql server 2005
1.create database ABC 2.backup database ABC to disk='D:backupDBABC.bak' Here i created a new database 'ABC'.NOW my DATABASE is empty(no objects where created), i am taking full back up,the out put i am getting OUTPUT: Processed 152 pages for database 'ABC', file 'ABC' on file 1. Processed 2 pages for database 'ABC', file 'ABC_log' on file 1. BACKUP DATABASE successfully processed 154 pages in 0.267 seconds (4.698 MB/sec). MY dout is even though my database is not having any objects,why it is backup 152 pages data file, i did't done any transations even why it backuped 2 pages of log files. 2) AGAIN when i take the LOG BACKUP ,with out doing any transaction again it showing that " 2 log pages where backuped" backup log ABC to disk='D:backupDBABC.bak' OUTPUT: Processed 2 pages for database 'ABC', file 'ABC_log' on file 2. BACKUP LOG successfully processed 2 pages in 0.056 seconds (0.219 MB/sec). 3)AGAIN when i take the log backup ,it showing 'ZERO pages backuped'(no transation were done) backup log ABC to disk='D:backupDBABC.bak' OUTPUT: Processed 0 pages for database 'ABC', file 'ABC_log' on file 3. BACKUP LOG successfully processed 0 pages in 0.033 seconds (0.000 MB/sec).

Software/Hardware used:
SQL SERVER 2005
ASKED: June 9, 2010  3:19 AM
UPDATED: June 16, 2010  12:46 AM

Answer Wiki:
There's a lot of meta data within the database which is created when the database is created. All of this is logged within the transaction log.
Last Wiki Answer Submitted:  June 16, 2010  12:46 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _