Posts
Sort by recent activity
Database growth?
Question: will SQL Monitor show me the size of my database over time so that I can estimate growth rate for capacity planning? If SQL Monitor won't give me this info out-of-the-box, can I (or you?...
SQL Backup 5 Hangs
A full backup using SQL Backup 5 hangs -- tried three times and finally killed each attempt after 10+ hours. No file was ever written but no error issued and the time-line display showed the Full ...
SQL Backup 5 Hands
Trying to do a full backup using SQLBackup. DB Size + Log is approx 350GB. 560GB available on the drive I want the backup to go to. Currently doing log shipping using SQL Backup and works fine. ...
Duplicate entries in Activity History?
I am using Log Shipping. The Activity History tab for SQL Backup on the destination machine (the one doing the restores) shows two entries for each restore -- one with the red SQLBackup "safe" ico...
Taking database out of Restoring state
My log shipping restore job died with a corrupted file. I want to take the database out of the restoring state -- I use the command RESTORE DATABASE [dbname] WITH RECOVERY and get the following er...
corrupted tlog in log shipping
Hoping someone can recommend a workflow here -- over the weekend our log shipping job stopped due to one of the tlog files being corrupted. unfortunately, I had set the file retention time on the ...
Log shipping and "regular" backups
We just set up log shipping on a test database between two data centers on opposite sides of the US and it works great (thanks Red Gate!). When we add log shipping to our production databases, I'm...
Log Shipping: Problem with network share
Hi,
I have two data centers and am trying to setup log shipping from a machine in center A to one in center B. Using SQL Backup Log Shipping wizard, I was able to configure a test machine in cente...