Comments
Sort by recent activity
We are using compression level 3 / comments
We are using compression level 3
At this point I have change the job script and moved compression level to 2 and removed the THREADCOUNT option. Should this create some stability in the backup job when the memory becomes fragmented or should I also look at setting the MAXDATABLOCK option as well?? / comments
At this point I have change the job script and moved compression level to 2 and removed the THREADCOUNT option. Should this create some stability in the backup job when the memory becomes fragmente...
Sorry to disagree - when running the following command I get the error below - It would appear that the backup files are corupted
EXEC master.dbo.sqlbackup N'-SQL "RESTORE LOG [PRD] FROM DISK = ''G:\Logship\bad\PRD_10242007_145501_LOG.sqb'' WITH MAILTO_ONERROR = ''xxx'', ERASEFILES = 2, NORECOVERY, FILEOPTIONS = 1 , MOVETO = ''G:\Logship\Applied'', PASSWORD = ''xxx''"'
SQL Backup v5.2.0.2824
None of the backup files are encrypted.
Restoring PRD (transaction logs) from:
G:\Logship\bad\PRD_10242007_145501_LOG.sqb
Thread 0 error:
Data decompression error: ZLib decompression error: data error
Thread 1 error:
Data decompression error: ZLib decompression error: data error
Thread 2 error:
Data decompression error: ZLib decompression error: data error
SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally.
SQL error 3203: SQL error 3203: Read on 'SQLBACKUP_E5B3F5E8-3707-4CF4-AB94-3B25CF95B07401' failed, status = 995. See the SQL Server error log for more details.
Warning 151: MAILTO error: Failed to send mail. (Socket Error # 10060 Connection timed out.)
SQL Backup exit code: 790
SQL error code: 3203
(17 row(s) affected)
name value
exitcode 790
sqlerrorcode 3203
(2 row(s) affected) / comments
Sorry to disagree - when running the following command I get the error below - It would appear that the backup files are corupted
EXEC master.dbo.sqlbackup N'-SQL "RESTORE LOG [PRD] FROM DISK = ''...
My issue with the first error is that Sql Backup is telling Sql Server that a successfull backup has taken place but when Sql Backup tries to use these files it is unable to do so thus breaking the log chain. At this point I have two issues First I can not do a point in time recovery since 2:55pm yesterday and Second for my DR solution to work I now have to ship the tape that has the full backup (150gb backup file) to the DR site and then start rolling the logs to catch up again.
Not sure if this is possible but it would be nice if Sql Backup was sure the backup file had been written out before it acknowledged to Sql Server that a sucessfull backup had taken place. / comments
My issue with the first error is that Sql Backup is telling Sql Server that a successfull backup has taken place but when Sql Backup tries to use these files it is unable to do so thus breaking the...
sent you an email with the backup command - unable to send the backup file because of size restrictions on our email system - is there a way I can upload the file to you??
Thanks, / comments
sent you an email with the backup command - unable to send the backup file because of size restrictions on our email system - is there a way I can upload the file to you??
Thanks,
backup file is 20mb / comments
backup file is 20mb
Here is the info from the backupset table - it appears that sql thinks the backup was good.
backup_set_id name description user_name first_lsn last_lsn checkpoint_lsn database_backup_lsn database_creation_date backup_start_date backup_finish_date type backup_size
----
17430 Database (PRD), 10/12/2007 12:45:02 PM Backup on 10/12/2007 12:45:02 PM Server: SWCS46CI Database: PRD NT AUTHORITY\SYSTEM 221616000013121100001 221616000024085800001 221616000022630000001 221612000010702100001 2007-09-09 03:55:03.000 2007-10-12 12:45:02.000 2007-10-12 12:45:04.000 L 56754176
(1 row(s) affected) / comments
Here is the info from the backupset table - it appears that sql thinks the backup was good.
backup_set_id name ...
Local admin group is still in sql and has sa rights. I have gone so far as to create a new group and give it access to sql and give it sa rights, the users of this group will get the error but when their windows account are granted access individually and given sa rights they do not get the error. I would prefer to grant access via a group and not individually. This appears to be random and does not happen on every install. / comments
Local admin group is still in sql and has sa rights. I have gone so far as to create a new group and give it access to sql and give it sa rights, the users of this group will get the error but when...
version 5.1
When using our windows account to log in we get the following error:
IDXJDEPD5\IDXJDEPD5: Restore - Failed
=====================================
Restoring full backup - Failed
This operation failed with errors.
Restoring test (database) on IDXJDEPD5 instance from:
\\SCIDXSQL64MSDTC\w$\backups\pd5\HOLDING_09102007_055254_FULL_02.sqb
\\SCIDXSQL64MSDTC\w$\backups\pd5\HOLDING_09102007_055254_FULL_01.sqb
Error 890: RESTORE DATABASE permission denied for database: (test)
SQL error 15404: Could not obtain information about Windows NT group/user 'CMD\bills', error code 0x5.
SQL Backup exit code: 890
SQL error code: 15404
Updating SQL Server information - Pending
Operation pending. / comments
version 5.1
When using our windows account to log in we get the following error:
IDXJDEPD5\IDXJDEPD5: Restore - Failed
=====================================
Restoring full backup - Failed
This ope...
I am running under a domain account, I have switch to another domain account and I am getting a different error now. Again this account is a local administrator on the server.
DLEKAENT03\SQL2005: Backup - Failed
===================================
Performing full backups - Failed
This operation failed with errors.
Backing up ACS (full database) on SQL2005 instance to:
w:\backups\ACS_09102007_190838_FULL.sqb
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
elapsed.)
SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3201: Cannot open backup device 'SQLBACKUP_A74B1712-16A8-4BF2-9F22-0EC20F3D941D'. Operating system error 0x80070005(Access is denied.).
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 795869184 4096 2014377 892 1796825088
Reserve 4128768 8192 274095 134 36728832
Free 161202176 4096 1999134 157 313864192
Private 795869184 4096 3137206 560 1756835840
Mapped 1060864 4096 107953 59 6369280
Image 24735744 4096 172847 407 70348800
Warning 300: Backup failed. Retry attempt: 1
Warning 300: Backup failed. Retry attempt: 2
Warning 300: Backup failed. Retry attempt: 3
Warning 300: Backup failed. Retry attempt: 4
SQL Backup exit code: 1010
SQL error code: 3201
Updating SQL Server information - Successful
This operation completed successfully. / comments
I am running under a domain account, I have switch to another domain account and I am getting a different error now. Again this account is a local administrator on the server.
DLEKAENT03\SQL2005: B...