.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Transaction log for database 'adv' is full?

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
Iam getting the error. the error is as follows The transaction log for database 'ADV' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases. But i have seen the log_reuse_wait_desc column in sys.databases. the status is "CHECKPOINT".  previously i have seen the status is "NOTHING" when previously i got this error. Can you please help on this..? Thanks Anil

View Complete Post

More Related Resource Links

SSIS - DB - The transaction log for database 'PROD' is full


Good day,

I get the following message "The transaction log for database 'PROD' is full" the DBA cleared it up last week and is currently on leave & and i urgently need to complete before the end of weekend.

It is a liv Database, how do i Safely clear the Transaction Log?





SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!

Full database backup takes so long

Today several full database backups took so long. Normally it took 2 hours to backup. But today the 5 backups didn't finish by the end of the work day. The backups went well until yesterday. I don't know what happened overnight. Is there a performance tool embedded in SQL Server? How can I find out why the backups take so long? What could be the possible reasons? Thank you,  

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

Simple Recovery Model Yet Transaction Log Is Full

Hi there, There's a database which has been configured with SIMPLE recovery model but yet the transaction log will grow and fill up the disk at times. Is there anything one can do to prevent the log from filling up the disk? Thanks in advance.

Do I need free space when doing full database restore in SQL Server 2005?


I have a drive 'F' with 40G free space. I try to restore a database whose data + log file size is 60G.

The restore fails. Is it because a full restore needs  free disk space of 60G in this case?


Can i use Windows desktop search indexing service to index a full sql database ?



i wonder if i can use the windows indexing service to perform indexing on a database instead of file system ?

i.e we need to use the windows indexing service to create index table that contains information from all rows in the database



TF30042: The database is full on SQL 2005 DB


One of our Devs was cleaning out some old workspaces from a user no longer with the company so we could reclaim files the user had checked out. He was running the tf workspace /delete command: and got the following message. TF30042: The database is full. Contact your Team Foundation Server administrator.

Based on some blog posts I verified that the Recovery mode was already in Simple. There was plenty of remaining drive space on the drive the DB/Logs live on. The Files settings are shown below and the databse is currently is 285MB and the log file is currently 56.3MB so I don't see where there would be a problem. We havent had any other reports of this error and devs are checking data in and out of TFS.

Any ideas?

AutoGrowth = Checked
File Growth
        In MB = 1
Maximum File Size
        UnRestricted File Growth

Log File
AutoGrowth = Checked File Growth
      In percent = 10 
Maximum File Size
     Restricted File Growth (MB) = 2,097,152

Lossless Audio Addict

Database blocking while performing a transaction scope?



I was running my application where i enter a transaction scope and perform a number of transact-sql statements. I was doing this while running the application in VS2008 in debug mode. My question is if i take a break while the debugger is at a breakpoint, will this block other users from using the database?


ilikecoding but i also like to take a break every once a while... :-)

When creating a database and SETing defaults should the TSQL statments be packaged as a transaction?


I'm a long time programmer but new to ADO & TSQL...

I'm looking to DROP (if it exists) and then CREATE a database in C#/ADO and then make some calls to ALTER DATABASE [myDB] SET ....

Since these are all affecting the master db, should these calls be wrapped inside of a transaction and if so at what IsolationLevel?

Thanks in advance - PMB


Is a database online when it is changed from full to simple recovery model?



We have some databases that occaisally have very large ldf files and I have learned that the best way to shrink the ldf file is to change the backup mode to simple, shrink the log file, convert it back to full and do a full database backup so that the log file backups will run again. My question is during this process is the database available to the end users? When you guys do this do you feel it is nessesary to let the end users know or will they not notice what is going on?



Thanks! Kevin

SharePoint 2010 backup is failing - Error - "Unable to read full interval from database - Operation



I am having a problem backing up a site collection, when trying to backup the collection I get the following error "Unable to read full interval from database" and "operation is not valid due to the current state of the object".

The backup does run and manages to backup 182MB of the site collection and then the backup fails, it fails at the same point what ever backup method I use e.g. STSADM, Powershell or Central Admin.

I'm getting the same error whether I use CA "granular backup" or "Farm backup", and using either STSAMD or Powershell. I can backup CA or the mysite collection but not the Home Portal site collection. I even tried installing the commuvaults 2010 agents and running a commuvault backup but this is also failing. i have included the log file entry below.

Does anyone have any suggestions on what i can do to either fix the problem or an alternative way to backup the collection or farm, I am currently taking a full SQL backup but am not sure how reliable this is as I haven't tried to restore the sites. 

P.S. I am not using the "UseSQLSnapshot" parameter.

11/30/2010 09:34:25.23  OWSTIMER.EXE (0x17E8)                 

Point In Time Recovery of Database with Full-Text Search enabled SQL 2005


Is this possible? 



Backup made at 10:30

changes made in system

Tail of the log backup taken at 10:35

Restore to point in tim 10:33 

At this point I get the error System.data.sqlclient.sqlerror: The File "sysft_yadayada_1" was not fully restored by a database or file restore.  The entire file must be successfully restored before applying this backup set.

BUT when I restore the database to most recent possible I have no issues..

when I do a select * from sys.master_files    sysft_yadayada_1 does not exist in that list, but  sysft_yadayada_5 does... When we were initially configuring fulltext search for this application we had a couple hiccups first till we got it working and thats the filename that ended up sticking.


Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend