Reg. Secondary Datafile
-
Dear Gurus,
Last year I created one database with only primary datafile. Due to more transactions, the size of the file keep on increasing, last month I added a secondary data file with the DB. Y'day I checked the datafiles, there is no difference in the size of Secondary datafile.
My question is when will be dbwriter write in secodary datafile, or is there any option to change it online. Bcaz the Primary datafile MAXSIZE is unlimited?
Please forgive me, if there any mistake on my question.
Jayakumar K.
Thanks
Jay
http://www.sqldbops.com -
Depending how you created the second file it may need objects allocated to it. So if you created a secondary filegroup for your file unless you assign objects to that filegroup it will remain empty.
If it's just a scond file then new data should be placed in that file until the file sizes match after which the data shoul be balanced between the files. ( or that's how it appears anyway )
I suspect that creating a new database with multiple files is the way to go rather than adding a file. Splitting current data is achieved by adding filegroups and allocating to the filegroup ( which could include multiple files )
hope this helps
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
If you created the second file in the same file group, you can set up the max limit for the first file with no autogrow.
If you created second file in a new file group, as Colin said, you need to move some tables into it. If a table has clustered index/PK, you can drop index/pk and recreate it in the new filegroup. In this way, the table will be moved to the new file group
-
Trouble with dropping a PK, is that you will have to drop / create the FKs that relate to that PK (if any), and should look at indices as candidates as well.
Some pretty good scripts for the this task:
http://www.sqlservercentral.com/scripts/contributions/1526.asp
There are also a load of other drop/create, indexing, and other DBA tasks on this site, Search is your friend...
Andy
-
ramazan_erdem (11/22/2008)
is there any program about this problem.but it must be full. or you have a karnel sql database reovery program's crack.i tried your commands but i could not fixed th problem. maybe problem is me. so i must fin this program crack...thanks to everybody...
Cross post, fwiw
-
Removed the post that are irrelevant.
The data files get written to in a round robin fashion if they are in the same filegroup. Current objects stay in their own files.
Are you looking at the OS size or the internal size?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply