Backup method 1

[nDAa]

Hi,All

I created a job for backup database by (Managemet->SQL Server Agent-> Job --> New Job ) the result is
bckdata.bak 197474 KB

and then I manual backup by (select database and click right select All Tasks -> Backup database )
the output is bckdata.bak 197459 KB

I wonder why the file size is not same ? (during the process ,nobody access to database)


Thank you
Ndaa

 

[mrdenny]

Previously commited transactions were probably removed from the database, or the system found some better way to compress the data when backing it up this time.

Unless it changes a lot (read that as a several megs or more) I wouldn't worry about it to much.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)