Search results for query: *

Three backup jobs have been set up via maintenance plans on our server. After a server reboot two of these jobs fail with the error message "The job failed. The owner () of job Transaction Log Backup Job for DB Maintenance Plan 'Daily DB Backup' does not have server access." Amending the...

I have configured log shipping in our SQL 2000 Standard Edition by following the process detailed in this link: http://www.sql-server-performance.com/sql_server_log_shipping.asp Each time a backup runs (database or transaction log) the backup device is overwritten. If the standby server...

I am trying to run the following command to execute a stored procedure on my DR server from my live server: exec georgia-dr.logshipping.dbo.restore_database_backups This is scheduled via a job on the live server. The job fails with the following message: Error 170: Line 1: Incorrect syntax...

I am attempting to start my master database in single user mode using sqlservr -c -m. After 40 mins the command is still running. Is this correct or should it be instantaneous?

Is there any possible way that I can restrict access to Enterprise Manager? Currently anyone who has access to our server is able to open Enterprise Manager which is obviously not advisable! Do you know how I can password protect Enterprise Manager thus prompting, for example, for the sa...