Search results for query: *

For information I reviewed the owner of the jobs and noticed that the jobs failing were running under the local administrator while the successful job ran under the domain user. I've changed them all to run under the domain account and that seems to have fixed the problem. Thanks for pointing...

Many thanks for the updates. For information the services are running as the local administrator. I've taken a look at the jobs scheduled through enterprise manager and cannot seem to find an option to change the owner. I've created them as part of a maintenance plan but don't believe that...

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...

Unfortunately our Network team have adopted this format for our DR server names so there is little I can do to change the server name. Many thanks for your help. The square brackets work a treat!

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 originally attempted to run the sqlservr command while the services were running but the command errored complaining that the errorlog file could not be found. Shutting down the services and running the command again resolved this error. I have since managed to put SQL server into single...

The -c option will make it a faster shutdown (as far as I'm aware.) I've also tried it without this option and it still hangs at the point "SQL global counter collection task is created". I have run the command after shutting down the SQL services so there shouldn't be any processes running at...

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?

Our Windows 2000 server where SQL server is installed is permanently locked and only IT staff have access to unlock it/know the password. However, we are trying to restrict access to our databases by only allowing the DBA team to run up Enterprise Manager. I'm therefore hoping to find a way of...

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...