Comments
Sort by recent activity
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...
here is some more information
I am running the red gate service and the sql service under a domain account, I have tried several even my own. If my windows account is given rights to the sql server via a group as in local administrators I get the error below. If I give my windows account right to sql individually I do not get the error. Any ideas as why this is happening as it has not been an issue on all of our installs??
DLUCOSQL01: Backup - Failed
===========================
Performing full backups - Failed
This operation failed with errors.
Backing up ACS (full database) to:
w:\backups\ACS_09132007_151700_FULL.sqb
Error 880: BACKUP DATABASE permission denied in database: (ACS)
SQL error 8198: Could not obtain information about Windows NT group/user 'CMD\BILLS'.
SQL Backup exit code: 880
SQL error code: 8198
Updating SQL Server information - Successful
This operation completed successfully. / comments
here is some more information
I am running the red gate service and the sql service under a domain account, I have tried several even my own. If my windows account is given rights to the sql server...
Never mind it too a little while for the drag and drop to take effect :? / comments
Never mind it too a little while for the drag and drop to take effect :?
All I am seeing is "Operation in progress" am I missing something?? SQL Backup 4.6 would show a % or GB completed and for some reason I am not seing this in version 5 / comments
All I am seeing is "Operation in progress" am I missing something?? SQL Backup 4.6 would show a % or GB completed and for some reason I am not seing this in version 5