September 23, 2013 at 12:11 pm
Following error messages are logged in SQL Server 2000 instance.
Database model: IO is thawed
Database master: IO is frozen for snapshot
The log for database 'tempdb' is not available..
I dug into the issue some more and in the SQL Server log add found that immediately after the completion of Auto snapshot backup of all dbs. Since that process is very large, the tempdb might have been effected
September 23, 2013 at 12:39 pm
Heard this from application owner:
The dbs were not able to do any work because all temporary space was full. The resolution was to restart the server, releasing the temp space and restoring access. Users received a message indicating that the temp file was full and were not able to do anything.
This has happened once that I know of in several years – we would like to know if we can re-engineer the back up process or take some other action to prevent this occurring again.
September 24, 2013 at 8:45 am
friends,
any inputs on the above issue?
September 24, 2013 at 8:46 am
Those IO messages are normally associated with a backup process that uses VSS to do backups. Here's a blog post about it that has some links to some articles
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply