Activity overview
Latest activity by kepr00
Incorrect schema change choice to rename a column.
This is the scenario.
I have a table called myTable that originally had an INT column called AccountID
There was a foreign key to the Account table.
I made a schema change to Drop the AccountID col...
RESTORE LOG is terminating abnormally
Hello,
I am receiving the following errors in the sql log.
12/14/2012 2:47:58 AM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything e...
Stack Trace
Hello
I am using SQL 2008 MGT Console.
Sql Prompt 4.0.2.27
I have the Master database set as the context of the query.
When I click on the condition for the Left Join below, I get the stack trace b...
Log Restore too recent to apply.
Hello
I am currently on SqlBackup 5.4.0.55
I have implemented a fully automated log ship restore process.
Periodically i receive this error.
SQL Server error
SQL error 3013: RESTORE LOG is terminat...
SQL Backup Reporting a failure but actually succeeding
Hello,
I am getting the following warning from Sql Backup:
Warning 300: Backup failed. Retry attempt: 1
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance i...
Thanks Brian I'll do that in the future. I still have one question however.
In an attempt to troubleshoot further I used a never version of my application which had the 7.0.0.772 version of the DLL in question. I did not have any issues and that version was compiled with the "any cpu" directive.
So what that just an issue with the 6.2.1 version? / comments
Thanks Brian I'll do that in the future. I still have one question however.
In an attempt to troubleshoot further I used a never version of my application which had the 7.0.0.772 version of the DL...
Could not load file or assembly RedGate.SQLCompare.Engine
I have a rather interesting issue. I have an application that is using the SQLCompare Engine. I have never had trouble with it before, but on this particular serve I am getting an exception. Coul...
The GUI Does not support editing the command you selected
Hello
I have an interesting problem editing a SQL Full Backup Job Created with the SQL Backup GUI.
Steps
Create a full backup job that includes all databases on a server.
Save the Job
Now edit the ...
There are no brackets in the password.
From the help file, this is a sample that I was working from
master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = ''C:\Backups\pubs.sqb'' WITH PASSWORD = ''MyPassword'' " '
Alternatively, you can use square brackets instead of two single quotes:
master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = [C:\Backups\pubs.sqb] WITH PASSWORD = [MyPassword] " '
I did, however, do some further troubleshooting.
My actual password has an ascii 178(dec) or B2(hex) character in it which is a superscripted 2. This seems to be where the sqlbackup procedure is failing. When I create another backup without using this character, everything works in both the sql Command tool and the SqlBackup stored proc.
So it seems that the SqlBackup stored procedure has some difficulty with ascii characters above 122(DEC) or 7A(HEX) where the command line SqlBackupC command has no such issues.
It would be nice to see this limitation removed in a future release of SqlBackup.
BTW, I also got an exception in this post when I tried to use the actual character in the body of this message.
Thanks. / comments
There are no brackets in the password.
From the help file, this is a sample that I was working from
master..sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = ''C:\Backups\pubs.sqb'' WITH PASSWORD = ...
Trouble with SQL Backup stored proc
Hello
I am having difficulty with the SQL Backup stored procedure.
This is the syntax I am using.
Use [master];
EXEC sqlbackup '-SQL "Restore Database MyDB From Disk=[D:\path\backup.sqb] With MOVE ...