backup won't complete
I just downloaded and am trying the latest release (22.214.171.124, btw, i like the picture of the SQL Backup 5 team, maybe smile more next time .
When I tried a full backup, I look at the process and the I/O Read bytes basically gets "stuck" - it doesnâ€™t move along.
I cannot kill the spid or process (once I've let it go long enough and have determined that the backup isnâ€™t happening - or over 24 hours). Basically, I can only stop SQL Server to stop the process.
The backup command:
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [xxx] TO DISK = ''D:\mounted\backups2\prod\db\<AUTO>.sqb'' WITH COMPRESSION = 1, THREADCOUNT = 7"'
Server = win2003 x64
backup destination volume has more than enough free space.
I donâ€™t see any log files that I can pass along to you from the following directories â€“ but I might be missing something.
C:\Program Files (x86)\Red Gate\SQL Backup
C:\Documents and Settings\Administrator\Application Data\Red Gate\SQL Backup
The errors that I get in the SQL Server error log is:
BACKUP failed to complete the command BACKUP DATABASE smarsh. Check the backup application log for detailed messages.
And in the app error log the messages are shown below:
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1320. Thread=4936. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_0348B23D-4BD9-44FA-888E-348995C3A28F_SQLVDIMemoryName_0.
SQLVDI: Loc=WaitForResource. Desc=Partner process aborted. ErrorCode=(0). Process=1320. Thread=4936. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_0348B23D-4BD9-44FA-888E-348995C3A28F_SQLVDIMemoryName_0.
So far I really like the GUI and the tool, but getting a full backup is critical to trial. Thanks for any input you could provide to help out.