September 22, 2008 at 7:44 pm
Hi All,
My backup failed last night with error 112 (unknown) - I have several GB left on my disk and it failed on the master db which is not that big. Can anyone help me?
Also One of my transaction logs is 8GB so I thought maybe that may be an issue - can you shrink the translog with people still on the system?
September 23, 2008 at 1:25 am
What's the message that was written into the error log?
You can shrink the log while people are on the system, but you shouldn't be shrinking the log at all.
How big's the DB?
Full recovery?
Log backups?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2008 at 2:11 am
You need to shrink your transaction logs on production
You may also need to set the recovery model of your database to Simple before you shrink your database if it's not already at simple.
September 23, 2008 at 3:13 am
BackupMedium::ReportIoError: write failure on backup device ',dbpath'. Operating system error 112(error not found).
It did this on most of my database. I have about 100 dbs all up. One database 6gb and log is 8gb. Most others are small (20 mb). One thing I did was change the recovery model to full from simple on all dbs for a few weeks but has been changed back again.
September 23, 2008 at 5:30 am
What is backup device 'dbpath'? Is there enough space on the disk?
If you're running in full recovery, you must run log backups. If you don't the log file will grow. Since you've switched back to simple, shrink the log down to a reasonable size.
Do be aware though, that in simple recovery, you are limited to restoring a DB to the last full/diff backup. With log backups (in full recovery) you can potentially restore right to the point of failure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply