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.



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 add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  


what is create database syntax? : Sql server database administration

0 Answers  


How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,


explain the storage models of olap? : Sql server database administration

0 Answers  


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,






What is onf in normalization form?

0 Answers  


What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,


how to know Who Is Blocking Your SQL Server?

4 Answers  


What is the full form of ddl?

0 Answers  


Explain few of the new features of sql server 2008 management studio

0 Answers  


How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,


What is difference between view and materialized view?

0 Answers  


Categories