Posts
Sort by recent activity
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...
Reduce DR restore time -- importance of msdb
Need you help
I am trying to make best use of Redgate SQL back v5 in a DR situation.
I sssume Redgate SQL Backup v5 uses msdb to know the history of each backup. There are 2 options Redgate uses t...
Backup job failed to start
Need help.
Redgate 5.3 was used to set up jobs to perform hourly transactional backups on many servers. Worked great for weeks with no problems. When I came in from the weekend to check on progress...