Hello, I've been having some problems with my Maintainance plan in SQL Server 2000. It will occationally quit working for days at a time. Sometimes it will do everything but back up the databases, and it steadfastly refuses to delete log backups over 6 weeks old (as I have asked it to). Anybody have any advice for me? Please, someone tell me the only thing to do is to take it out in the parking lot and kick it around. ThanksThere isn't anything else on the server (Win 2000), and its configured to stay powered up all the time. Theres also no significant traffic when its configured to run.
Thanks|||I would like to know if there is any other way of allowing a user to be able to run maintenance plan or create databases without being sysAdmin.|||GRANT DUMP DATABASE , DUMP TRANSACTION TO <user_name>
go
exec sp_addsrvrolemember <user_name>, dbcreator
go|||http://support.microsoft.com/default.aspx?scid=kb;en-us;288577 KBA to troubleshoot Maint.plans.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment