"The Log File is Full" error when I try to add connection of SQL Server 2008 in Visual Studio 2008.?

Question

When I try to add new connection to SQL Server 2008 database, this error comes and cannot add connection. I can access database through programming but cannot add connection manually.

Please help. My application development is stopped due to this error....

Answer 1

This means the file which tracks changes to the database has run out of space. Whoever is maintaining the application's database needs to fix this - if done thru a website, contact the webmaster; if an internal company application, contact the company's database administrator.

Answer 2

If it is organized like most data centers you have to contact your system administrator.. It bothers me that Microsoft doesn't have a decent log or logrotate, and that manual intervention is necessary.

Answer 3

It relies upon on the language you're making use of to execute the sq. assertion. maximum languages open a particular database (AdventureWorks, on your case), so all sq. statements are engaged on that database and you do not could desire to specify it.