1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

one of my database size is 2gb and Unrestricted Growth for
Data file up to 10%.But every day after day I am getting
Primary Data file is full 99.999 please take appropriate
actions.Why it is? Even disk space is also not full,but
still I am getting the alerts.

Question Posted / vamsimadineni


one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after..

Answer / sandeep

Hi,
First check/review the codes written to generate the Alert.

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More SQL Server Interview Questions

How to execute a sql statement using mssql_query()?

0 Answers  

explain different types of joins? : Sql server database administration

0 Answers  

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

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

0 Answers  

How can you list all the columns in a database?

0 Answers  




Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

What is the default value of an integer data type in sql server 2005?

0 Answers  

In which files does sql server actually store data?

0 Answers  

what is index seek and index scan?

2 Answers  

What is unique key constraint?

0 Answers  

What is the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories