ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
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.
 Question Submitted By :: Vinod
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
# 1
You will have to backup the Transaction Log. You may 
schedule a job which backs up the log every night.

Backup the log before shrinking the database.
 
Is This Answer Correct ?    0 Yes 0 No
Nixo
 
  Re: 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
# 2
try allocate a room for taht log file
 
Is This Answer Correct ?    0 Yes 0 No
Rama Krishna
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is a sub-query? When would you use one?  2
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?  1
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........  1
what is Data Transformation Services (DTS) ?can u explain me in detail? TCS4
how to delete duplicate rows from table CSC2
How do we return a record set from a Stored Procedure in SQl server 2000?  2
what is web server? Satyam3
how can do you the system monitoring?  1
How to link up the text file to a Database table? Allianz1
what are file groups? Evalueserve3
In clustered and non clustered indexes which one is faster while executing a query ?  1
how to get 25th row in any table in sqlserver can u tell me syntax  4
What is user stored procedure & it purpose? Wipro3
How to work on DTS?what is the main requirement? ivan1
What is the default value of CHAR type? Bosch6
how to get the rowid/rownumbes of a table in sqlserver IBM1
what are three different authentications to connect linked servers? CitiGroup1
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error? IBM1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com