Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Autogrow + New Data Files

Hi There

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.

Use Master
go
Alter Database EPR
Modify File
(Name=EPR_DATA ,Size=20000mb)
go

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.






0
Stanton_Roux
Asked:
Stanton_Roux
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>What are the implications of adding a new DAta File to the Databse.
additional space is available to the filegroup

>Does the data now go into the new datafile once the primary one is full.
no. data goes into that datafile immediately, distributing data as much as possible

>Will I looses any data if I add a new data file
no
0
 
Stanton_RouxAuthor Commented:
Sorry One more question

Will adding a new data file solve the problem that I currently have.
Will the both data files be backed up
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Will adding a new data file solve the problem that I currently have.
possibly.

>Will the both data files be backed up
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now