Comments
Sort by recent activity
Hi Peter,
We can try to establish on what thread number we have the failure....only prob is that the server is remote and an operational branch server and when we have an unexpected shut down someone has to be on site to physically power off the server to get it up again.
Other than what you have suggested can we try something else?
I made mention in my original post that we were getting this on about 7 new HP ML350 servers, it looks like those have 'settled' down (without us changing anything) / comments
Hi Peter,
We can try to establish on what thread number we have the failure....only prob is that the server is remote and an operational branch server and when we have an unexpected shut down someo...
Hi Peter,
We ran those backups with no issues, pls see below:
Code:
BACKUP DATABASE [xx] TO DISK = 'c:\file01.bak', DISK = 'c:\file02.bak'
- run a SQL Backup backup to multiple devices and files e.g. Ran successfully
Code:
EXEC master..sqlbackup '-sql "BACKUP DATABASE [xx] TO DISK = [c:\file01.sqb], DISK = [c:\file02.sqb] WITH INIT"'
- run a SQL Backup backup to multiple devices and a single file e.g. Ran successfully
Code:
EXEC master..sqlbackup '-sql "BACKUP DATABASE [xx] TO DISK = [c:\file01.sqb] WITH THREADCOUNT = 2, INIT"' Ran successfully / comments
Hi Peter,
We ran those backups with no issues, pls see below:
Code:
BACKUP DATABASE [xx] TO DISK = 'c:\file01.bak', DISK = 'c:\file02.bak'
- run a SQL Backup backup to multiple devices and files e....
Hi Peter
Script below, I turned on the 'threads' before I copied the script for you because when that is selected we get the shutdown. With the threads turned off we have had 2 days with backups and the server has not shut down
This really is strange because I have been running Red-gate for years now on about 50 servers and never seen this
--Full script
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASES [*] TO DISK = ''C:\SQL BACKUPS\<AUTO>.sqb'' WITH COMPRESSION = 2, ERASEFILES = 5, MAILTO = ''Terry-Sue.vanRensburg@bidvestbank.co.za; Morne.vandermerwe@bidvestbank.co.za'', THREADCOUNT = 12, VERIFY"' / comments
Hi Peter
Script below, I turned on the 'threads' before I copied the script for you because when that is selected we get the shutdown. With the threads turned off we have had 2 days with backups an...
Hi,
We reinstalled the client again this morning and ran a backup which caused the server to shutdown.
I then unflagged the 'threads' option and the backup ran through without crashing the server.
How could the thread option do that?
Thanks
Russ / comments
Hi,
We reinstalled the client again this morning and ran a backup which caused the server to shutdown.
I then unflagged the 'threads' option and the backup ran through without crashing the server.
...
Hi,
We just checked the System and SQL log and there are no error messages prior to the shutdown.
Thanks / comments
Hi,
We just checked the System and SQL log and there are no error messages prior to the shutdown.
Thanks
Hi,
As per my previous post we uninstalled Red-gate and the server did not shutdown unexpectedly last night, so the start of the backup job causes the server to shutdown unexpectedly.
What settings can I check or could it be as simple as a corrupt install?
Reinstalling today to see the outcome
Thanks / comments
Hi,
As per my previous post we uninstalled Red-gate and the server did not shutdown unexpectedly last night, so the start of the backup job causes the server to shutdown unexpectedly.
What settings...