Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent.

Answer Posted / rajkumar

You should schedule the job for shrinking the database log.
or you have to minimize the growth of the log file.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How secure is sql server database?

994


What is the tcp/ip port on which sql server runs?

1140


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

981


What is acid db?

877


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2059


what are constraints? Explain different types of constraints? : Sql server database administration

971


How do I know if localdb is running?

941


How to change the system date and time from SQL Plus Terminal ?

1210


What you can do to delete a table without the delete trigger firing?

962


What to check if a User database is locked?

1054


What is meant by Active-Passive and Active-Active clustering setup?

1158


Explain different types of locks in sql server.

1068


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1031


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2579


Can we delete data from a view?

918