Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

application issue with these SQL errors Expand / Collapse
Author
Message
Posted Monday, September 23, 2013 12:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 202, Visits: 355
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
Post #1497489
Posted Monday, September 23, 2013 12:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 202, Visits: 355
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.
Post #1497501
Posted Tuesday, September 24, 2013 8:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 202, Visits: 355
friends,

any inputs on the above issue?
Post #1497916
Posted Tuesday, September 24, 2013 8:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:31 PM
Points: 11,265, Visits: 13,027
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1497920
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse