Search results for query: *

Hi, i have a few web jobs, that were set up by the DBA that worked here before I did and they have just stopped running and I have no idea why. The error I get is: Executed as user: dbo. SQL Web Assistant: Could not establish a local connection to SQL Server. [SQLSTATE 42000] (Error 16804)...

Hello all! Does anyone know what clustering is? Whether it is better than log shipping? And how difficult is it to set up? Thanks

Hi, On a nightly basis I restore a database called 'tmg2', from a backup set called 'tmg'. But everytime i do it I lose a user, the user still shows up in the database but you cannot log on using that user. I then have to delete the user and re-create it for the user to be able to log on again...

Hi, I have somehow managed to stop all jobs on my sql server from running, they do not show any error they just don't run when I try and execute them. I did try and transfer over some logins from another server to keep all logins synched, could this be why?

Hi, I have a restore job which is called from another restore job and it keeps failing, but the job history shows the job as passed......but it does not pass because the job runs for 0 time, but it is restoring a 40gb database and normally takes 20 mins or so. Anyone had this kind of prob...

Hi, I have a stored proc that calls two jobs, like so: exec pelican.msdb.dbo.sp_start_job @job_name= 'restore = alpha pm' exec pelican.msdb.dbo.sp_start_job @job_name= 'restore = Omega PM' Will the second job wait for the first job to complete before it executes?

Hi, I have a few maintenance plans and I have no idea which database they work on, how can I find out? If I look at the jobs' steps all I can see is this: EXECUTE master.dbo.xp_sqlmaint N'-PlanID BE090B40-9519-46C6-81A2-2B43A3568EDA -Rpt "d:\MSSQL\LOG\DB Maintenance Plan12.txt&quot...

Hi, i have just started a new job as a DBA, the company has survived a while without a DBA but this means too many people know the sa passwords. I would like to change the sa passwords for each SQL server, how do i go about adoing this? Will doing this have any detrmental effects on back up...

Hi, I just accidently deleted a database that was being log shipped to, and now it wont restore the logs. I restored the database, and when I try to restore the logs by running the old job it tells me this: Executed as user: sa. The preceding restore operation did not specify WITH NORECOVERY...