1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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.

Question Posted / vamsimadineni


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

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1 Answers  

How ssrs maintain security?

1 Answers  

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

1 Answers  

What is ms sql server reporting services?

1 Answers  

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

What is row_number () and partition by in sql server?

1 Answers  

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers   TCS,

Does sql server use t sql?

1 Answers  

What is transaction server distributed transaction?

1 Answers  

Where are sql server usernames and passwords stored in the sql server?

1 Answers  

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1 Answers  

For more SQL Server Interview Questions Click Here
Categories