backup database

[minyu1234]

I backup the same database using 2 different method, the file size is dramatically different. I would like your expetise input.

With Sqlserver agent, the file size is about 14 M.
With backup database command, the file size is about 44 M.
osql -E -Sservername -dmaster /Q "BACKUP DATABASE dbname TO DISK = 'filename'

Why the difference?

Thanks!

 

[tlbroadbent]

Are you doing a full backup with the SQL Agent? The smaller file could indicate a differential or transaction log backup.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm

 

[SQLBill]

When you say you are using SQLServer Agent, are you using a Maintenance Plan or did you create a Job?

-SQLBill

 

[minyu1234]

I use Maintenance Plan to create the job and then manually run the job at the time of comparison.

 

[Corran007]

post the sql command that is in job agent.