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

How do you identify a foreign key?

779


what's new in sql server 2016?

729


How would we use distinct statement? What is its use?

785


Why do you want to join software field as you have done your BE in Electronics?

1889


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

677






what is the primary use of the model database? : Sql server administration

728


How exceptions can be handled in sql server programming?

705


Why should we go for stored procedures? Why not direct queries?

749


How to connect to SQL Azure Database by using sqlcmd?

128


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

745


What are the different types of triggers in SQL SERVER?

723


List the data types available in mssql?

708


What is partition, how will you implement it? : sql server analysis services, ssas

795


How do I port a number to sql server?

698


What do you mean by a Composite primary key?

759