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

Difference between primary key and clustered index?

506


Explain log shipping and mention its advantages.

600


How to restore performance issues and how to check?

1527


How to use subqueries with the exists operators in ms sql server?

590


Explain the xml support sql server extends?

625






What are the types of ssrs?

108


do views contain data ?

590


What are “lock” hints?

595


How to skip remaining statements in a loop block using continue statements?

547


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

134


List the types of recovery model available in sql server?

507


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

644


How can you start sql server in different modes?

509


What is simple indexing method?

577


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

592