Adding a Secondary file in same filegroup

[antzzz]

I am using SQL Server 7.0 on Windows 2000 server. Initially, I used a 10GB drive (D to hold both my primary data file and log file. When my database size went up to 8 GB, I added another drive (E of 20GB size and added a new secondary data file to this drive.

I then put a maximum limit of 9GB on the primary data file. I put a maxsize of unlimited on the secondary data file.

They're still in the same filegroup. I've read that data files in the same filegroup are filled proportionally.

I have the follow queries:
1) When I made the secondary data file, was existing data transferred to the secondary data file from the primary? Or will it only be filled with new data?
2) What happens if my primary data file becomes full and reaches the maxsize limit, will I get an error that my primary data file has become full or will the secondary file takeover and keep on accepting new data coming in?

Any advice is appreciated.

Thanks

 

[mrdenny]

1. No.
2. The data will start being written to the second file on the new drive.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)