Solved

Autogrow + New Data Files

Posted on 2006-07-19
3
268 Views
Last Modified: 2012-06-22
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
Comment
Question by:Stanton_Roux
  • 2
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
>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
 

Author Comment

by:Stanton_Roux
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>Will adding a new data file solve the problem that I currently have.
possibly.

>Will the both data files be backed up
yes
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now