Comments
Sort by recent activity
The whole system freezes, mouse clicks and keyboard presses get no response from the server, although the mouse pointer still moves...
I cannot connect remotely via system management or sql management studio (they seem to hang as if waiting for a response) so I cannot query anything out.
Shortly after posting I did get a backup to run by running the backup to a different folder (same drive), on a hunch I then deleted the old backups and re-ran to the original location, it also ran fine...
It would have been nice, after the first successful backup, to re-run with the files in place however this is a live production server and downtime is not appreciated [image]
All of this may be coincidental but I will keep my eye on it and set the backup to 12pm (nothing like a phone call at 2am saying the system has frozen when you can't restart remotely!) and will keep my eye on it.
Regards,
Darren France / comments
The whole system freezes, mouse clicks and keyboard presses get no response from the server, although the mouse pointer still moves...
I cannot connect remotely via system management or sql managem...
This script is now working.
Regards,
Darren France / comments
This script is now working.
Regards,
Darren France
It was, thanks to Daniel for the fix.
Changed the service to run under the same domain account as the SQL Server Agent and backups have resumed. / comments
It was, thanks to Daniel for the fix.
Changed the service to run under the same domain account as the SQL Server Agent and backups have resumed.