Hard disk full

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Hard disk full

Hard disk full

Rate Topic

Display Mode

Topic Options

Author

Message

veloopity

Posted Monday, January 14, 2013 2:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:15 AM
Points: 8, Visits: 9

A customer has a large SQLServer 2008 database, it increases size every day because it is basically a statistics database with data added every day. A web application uses it to display statistics. Nothing happening transaction-wise, the data are just read and interpreted.

Today everything runs slowly and there are errors - we found that the hard disk is full.

What are the steps best taken now?

I'm just a programmer and not much of a database admin, so I'm not sure what to do.

-Michael

Post #1406621

anthony.green

Posted Monday, January 14, 2013 2:59 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

Add more space - if possible
Purge data - to release space from inside the data files, will need to be done in small chunks due to it needing to log the purge for ACIDity reasons
Perform index and statistic maintenance - to ensure everything is optimal for the queries being performed

What is the recovery model of the database

SELECT recovery_model_desc FROM sys.databases WHERE name = 'databasename'

What is the backup strategy for the database? How often are full, differential, transaction log backups done?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1406623

veloopity

Posted Monday, January 14, 2013 3:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:15 AM
Points: 8, Visits: 9

Recovery model says: SIMPLE :)

The backup command is

/SQL "Maintenance Plans\(databasename) Integrity und Backup" /SERVER (servername) /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E

done once daily.

-mpe

Post #1406636

anthony.green

Posted Monday, January 14, 2013 3:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

Ok, so your in simple, thats ok just would dictate the way to go when purging.

So the options are

1 - Add more disk space
2 - Purge data and perform index and statistics maintenace
3 - Both of the above.

Post #1406638

veloopity

Posted Monday, January 14, 2013 4:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:15 AM
Points: 8, Visits: 9

thx bunches!!

Post #1406649

ScottPletcher

Posted Monday, January 14, 2013 3:20 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:11 AM
Points: 1,333, Visits: 1,803

If the log is on the same drive, don't purge any data until you've given the log more space!

If the log is out of space, and particularly if it getting errors about it, you must add log space first. If necessary, you can temporarily add another log file on a different drive. First you must get the log file in working shape, then and only then can you safely purge data.

SQL DBA,SQL Server MVP('07, '08, '09)
One man with courage makes a majority. Andrew Jackson

Post #1406960

« Prev Topic | Next Topic »

Permissions