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.

Answer Posted / sandeep

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

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between user defined functions and stored procedures?

531


Write SQL queries on Self Join and Inner Join.

617


How do you migrate data from mssql server to azure?

151


what is a check constraint?

641


How to download microsoft sql server 2005 express edition?

575






What is a recursive stored procedure in sql server?

571


How many categories of data types used by sql server?

598


How would you go about developing a ssrs report?

110


difference between Clustered index and non clustered index ?

581


Explain database normalization?

647


Is port 1433 secure?

540


What are synonyms?

529


What are the options which must be set to allow the usage of optimistic models?

516


What triggers long term care?

563


What is cursors?

642