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