[MSSQL] Enabling Agent XPs

To enable the Maintenance Plans in MSSQL 2005

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

[MSSQL] Backup Using Query

BACKUP DATABASE
TO DISK=N'D:\\.zip'
WITH INIT, NOUNLOAD,NAME=N'',NOSKIP,STATS=10,NOFORMAT

Zip extension is not really a zip file but to be allowed downloaded through HTTP.