Posts
Sort by recent activity
Impact of VERIFY on Backups
We have the Backup Option "CHECKSUM" selected, but not "VERIFY"... would "best practices" be to have this option set? If yes, what is the "hit" in terms of processing speed? A lot of our databases ...
SQL Backup Restore Errors (End of File)
It appears all of the backups on our production (aka Prod) and development (aka Dev) servers are bad. While the logs indicate everything backed up fine, when we try to restore the backups we get th...
SQL Backup Error Messages
We recently had an interesting problem. We have a script to restore a lot of backups onto a secondary server. One of the steps is to capture the information about the backup file, i.e., <div>DECLAR...
SQL Backup Logs and fn_dump_dblog()
We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. There are a few undocumented functions for...
SQL Backup Logs and fn_dump_dblog()
We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. There are a few undocumented functions for...
SQL Backup 10 GUI/Restore Timeouts
We have been experiencing problems with one of our SQL Backup Pro instances, version 10.0.12. • Trying to do a restore via the GUI is extremely slow and connections in general are slow. • We experi...
Restore DB Works in SQL Pro 7 GUI, Errors TSQL Manually
I am trying to restore about 70 databases individually (to do some synchronizations on a few archive SQL servers) from a backup on SQL Server 2005 to SQL Server 2008 R2. When I try to run the follo...
SQL Scripts and Source Control
We recently purchased some additional RedGate tools, among them is the Source Control product. While we do need to add a "primary" Database to the Source Control paradigm, we really need to be able...
SQL Data Compare 6 versus 8 Command Line Options
I was working on re-setting a weekly database sync job using the SQLDataCompare [version 8] and it appears one of the command line options is no longer valid:
/ignoreadditional (Alias: /a)
Do not c...
Sync Fails due to Primary Key Constraint
I am trying to synchronize two tables in two different databases. The table structures are indentical (primary keys have different names but they use same key fields).
I tried to sync the databases...