Hi,

U can use XP_CMDSHELL and del those files (define a schedule job)before next backup job run , but be careful about using this extended stored procedure.

SaNaZ

Hi,

It's possible to mail sql backup result by CONFIGURING SQLMAIL. for more info see the link below :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q263556

and then u can set the sql backup job to...

Hi,

Tanx for all reply 🙂

SaNaZ

Hi,

I think that there is some consistency error in Master & MSDB dbs . To perform these check u can execute DBCC CHECKDB , DBCC CHECKALLOC , DBCC CHECKCATALOG commands....

Hi,

Try this stored procedure : "sp_spaceused". Maybe this will help u.

SaNaZ

This is the imporatant point four me I want to know who did this changes to the db. I mean how can I AUDIT changes in dbs, Ofcourse I activate...

Hi,

tanx Andy for ur reply.I create a new db and a login for it and put this user as db_denyreader & db_denywriter but when i check object's permissions everything was...