SQL agent compare with Microsoft agent.
Created: 12 Feb 2013 | 1 comment
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?
Discussion Filed Under:
Comments 1 Comment • Jump to latest comment
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.
Would you like to reply?
Login or Register to post your comment.