Posts
Sort by recent activity
SQL Compare 8 -- compare selected tables
Sometimes I just want to compare selected tables in 1 database to selected tables in another database but with different table name. For example, database 1 has table named X and in database 2 has...
Add Checksum option to verify option on the GUI.
Currently only the command line/SQL versions allows you can add checksum to the backups. Please add checksum to GUI version for SQL 2005 so the backup can be properly verified. Have it greyed out...
Restored database with focus on log size
Moving a database to another server can be more easily be done with Red Gate than attach detach methods when network is slow because the compression is so large and my copy time to the other server...
shrink transaction log back to default size
When a database is created, the default size of the database is 2MB and log is 1MB. Under the full recovery model, I know that the transactional backing up of the log only removes the unused part...
Use of Log shipping and normal transactional backups
Need your help.
Currently the database has transactional backups every hour, differential daily and fulls weekly. Can I use the normal transactional backups for log shipping? Would this scenario ...
Scrollable SQLView in Interactive HTML export
SQL Compare has the ability to export a comparison to an interactive HTML web page. The normal comparison page has a scrollable line which can be moved to seperate the objects from the line by li...
SQL Backup v5 -- PCI Compliance
Need to know if the Red Gate Backup version 5.x is PCI compliant with version 1.1 of the Payment Card Industry (PCI) Data Security Standard document.
We use your backup tool to compress and encrypt...
Restore wizard -- location of mdf and ldf
Need your help
I am rebuilding a new server and am restoring backups from an old server to this new server and have some questions.
a) When I use the wizard to "create" database approach, why does ...
backup and restore of mssqlsystemresource system database
SQL 2005 has 5 system databases and Red Gate SQL backup v5 can only backup 4 of the 5 system databases. What is your recommendation for backing up/restoring of the mssqlsystemresource.mdf database?...
shrinking log after truncate inactive portion of log
One of the mapped drives ran out of disk space and was forced to manualy truncate log and did a dbcc shrinkfile on the log file to recover many GB of disk space. Then did a full backup of DB so th...