SQL Server 2008R2 database is offline, and transact log file is full

My database has filled the drive with the transaction log, its about 15GB and the drive is now full. The database won't start. The database is currently offline.

I can access SQL Server Management Studio, but not sure what to do next to fix up the transaction log, and get the database back on line.

Answers


You would appear to have the database set to use the Full recovery model.

The log is supposed to be truncated when the database is backed up using a backup tool that integrates with SQL Server (at that point you have a snapshot of the DB at that point in time for recovery), but if you don't have an appropriate regular backup in place, the log tends to bloat out to fill the available disk space.

If you don't require the full recovery model, then change to the Simple Recovery model (right-click on the database node in SSMS, select Properties and go to the Options page) and then shrink the DB.


Need Your Help

Model in Sqlalchemy

python sqlalchemy flask-sqlalchemy

In each workspace i need to add many users, I need connection to for example 5 users how can i handle this sqlalchemy ?

Http File upload - Files over 25mb fail - PHP uploading script

php html http post upload

I've been banging my head against this for 20+ hours now I would really appreciate some help!

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.