Can not schedule backup on SQL user database or view tablesgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Looking for a solution to following:
The user database can not be scheduled for a backup. We believe that we have check all appropriate permission.
Additionally, while in Enterprise Manager we can not view the columns within the tables.
Any input appreciated.
Joseph A. Memmo
-- Anonymous, June 26, 1999
I suspect that the login that the Enterprise Manager is using does not have sufficient privileges.
Presuming you are using SQL Server 6.5, unregister the SQL Server in question. (In SQL Enterprise Manager, right click on the server name and select Un-Register.) Then right click the SQL 6.5 line and right click to Register the server. This time log in as sa (system administrator) and your problems will probably disappear.
Hope this helps,
-- Anonymous, June 29, 1999