Backup storage for sql server 2005

5 pts.
Tags:
Backup storage
SQL Server 2005
Storage in 2010
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following