Activity overview
Latest activity by SinclairSpeccy
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...
Unresponsive Server
Whenever I run a script, to backup a specific database using SQLBackup, after a few minutes the server becomes un-responsive and the only way out is to reset the server.
Script is as follows:
maste...
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.
This script is now working.
Regards,
Darren France / comments
This script is now working.
Regards,
Darren France
Old Script New Tricks
I have 2 backup scripts:
master..sqlbackup N'-SQL "BACKUP DATABASE [db_Import]
TO DISK = ''E:\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', VERIFY, ERASEFILES = 3, COMPRESSION = 3"'
ma...