Autogrow + New Data Files
Posted on 2006-07-19
Im having a problem with my DB where the Autogrow function is not working properly.
I have used the following script to grow the data file manually but it is taking extremely long to update.Its been 20 minutes so far.
Alter Database EPR
I also recieve this error when I try and run a transaction from my application
Could not allocate space for object 'Encounter' in Database 'EPR' Because the primary file group is full.
What are the implications of adding a new DAta File to the Databse.
Does the data now go into the new datafile once the primary one is full.
Will I looses any data if I add a new data file
does both data files get backed up when I back up the database.