Posts
Sort by recent activity
Backup Differencial error
Executed as user: ''. SQL Backup failed with exit code: 5160 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.
What error does this indicate?
Thanks,
Error: Rijndael: Invalid key size - 0, red gate
Error when attempting a restore. Version: 6.4.0.56
Backup failed on disabled sql login.
Greetings,
I recently disabled an old sql login, used by a former employee, now a database backup is failing with the following message:
SQL error 18470: Login failed for user ''. Reason: The accou...
Use Copyto or Mirror
Hey All,
I need to copy a full backup to a reporting server with a fixed name. The local copy gets an auto name. Can I use copyto to rename or choose a different name than the <auto.sqb> name given...
Problems with 2nd Copyto location
My backup script is erroring out on the second copyto location. I am guessing it is permissions, but I want to be sure the scripts looks alright.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXE...
How does 'copyto' work?
Does it create the local copy first, then copy that to the second location? How would that work if you had two 'copyto' locations, on 2 different servers.
Example: Server A backs-up database A, wit...
Password encryption
Is there a stored procedure/extented stored procedure that can be used to generate the encrypted strings without using the wizard/gui?
Thanks,
DK