2.backup database ABC to
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
152 pages for database 'ABC', file 'ABC' on file 1.
Processed 2 pages
for database 'ABC', file 'ABC_log' on file 1.
successfully processed 154 pages in 0.267 seconds (4.698 MB/sec).
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
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
backup log ABC to disk='D:backupDBABC.bak'
0 pages for database 'ABC', file 'ABC_log' on file 3.
successfully processed 0 pages in 0.033 seconds (0.000 MB/sec).
SQL SERVER 2005
June 9, 2010 3:19 AM
June 16, 2010 12:46 AM