Video Screencast Help

SQL agent compare with Microsoft agent.

Created: 12 Feb 2013 | 1 comment
HolyRoyal's picture

Hi all, there is question about sql agent.There is a SQL server database, the size of about 170 GB with built-in backup from Microsoft. If this server will supply agent for DB  of BE, what he will do in excess of what makes Microsoft for backup? What is the difference in principle Microsoft agent from the agent BE? Is there any compression, and how many times?

Comments 1 CommentJump to latest comment

pkh's picture

I don't know what Microsoft agent are you talking about.  If you are talking about the backup facility in SQL Studio, then the backup taken by the BE SQL agent is essentially the same because BE calls the SQL API to dump the database.

There is no way to predict the compression because it all depends on your data.