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

What are the various Isolation levels?

2 Answers   HP,


How do you load large data to the SQL server database?

2 Answers  


What is the need for indexing?

0 Answers  


How to make remote connection in database?

0 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  






Why do you need a sql server?

0 Answers  


Explain the properties of a relational table?

0 Answers  


What is msdb database? : SQL Server Architecture

0 Answers  


How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,


what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,


How to declare and use cursor variables?

0 Answers  


What are the system database in sql server 2008?

0 Answers  


Categories