Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 3rd September 2007, 07:23
idreaming2005 idreaming2005 is offline
Member
 
Join Date: Jul 2005
Location: China,Guangzhou
Posts: 47
idreaming2005 is on a distinguished road
Baan: BAANLN FP2 - DB: MS-SQL 2000 - OS: Windows 2003
Smile how to split .mdf file in sql server
Baan: Other/Unknown
DB: Other/Unknown
OS: Other/Unknown
C/S: None/Unknown

Our ERP server is windows2003+MS-SQL+BAANLN.
The database file .mdf set to automatically grow and with unrestricted file growth. Now the .mdf file grow to 80G.
My question is how to split the big .mdf file to several small one in MS-SQL server?
Please tell me the steps.
Thanks a lot
Reply With Quote
  #2  
Old 3rd September 2007, 14:21
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
mdf file

Probably http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56434 should help u .
Reply With Quote
  #3  
Old 3rd September 2007, 15:50
Darren Phillips's Avatar
Darren Phillips Darren Phillips is offline
Guru
 
Join Date: Aug 2001
Location: west wales, UK
Posts: 334
Darren Phillips is on a distinguished road
Baan: IV4c4 SCH1 SP14 /AGS2 - DB: SQL7/sql2000/Oracle 9 - OS: NT4 Enterprise / win2000/3
you can use mssql filegroups http://www.databasejournal.com/featu...le.php/1439801
so you also have NDF files. I once looked into this so that I could backup my archive and live company seperately in sql. the idea being I would do a dump of the archive company create a new filegroup. Via sql make this new ndf file the default for all new tables then restore archive company dump back to sql which would place all the archive tables into the new NDF file and then change the default back to the mdf file.
Reply With Quote
  #4  
Old 20th September 2007, 16:19
ajay130476 ajay130476 is offline
Newbie
 
Join Date: Apr 2007
Posts: 2
ajay130476 is on a distinguished road
Baan: IVc4 - DB: Oracle - OS: Unix
I have some steps?

Hi,
though I was searching for how to speed up my BDBPRE process, I saw you problem. I have step wise procedure in my documents. I tried to search it for u but could not. I used it on our test server and it splitted my MDF into small MDFs which can be stored on any partition of harddisk. Give me some time. If I get it I should give u.
Bye
Reply With Quote
  #5  
Old 20th September 2007, 16:27
ajay130476 ajay130476 is offline
Newbie
 
Join Date: Apr 2007
Posts: 2
ajay130476 is on a distinguished road
Baan: IVc4 - DB: Oracle - OS: Unix
Steps

EXAMPLE:

1 - To create new datafile and filegroup to store tables/indexes
of a new 567 company (Transac-SQL) :

/* Create a new "fg567" filegroup : */
ALTER DATABASE baandb ADD FILEGROUP fg567
GO

/* Verifiy It's OK : */
sp_helpfilegroup
GO

/* Add a datafile to this new "fg567" filegroup : */
ALTER DATABASE baandb ADD FILE
(
NAME = data567,
FILENAME = 'E:\msql7\Data\data567.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
TO FILEGROUP fg567
GO
Note: You need to mention correct filename path
/* Verifiy It's OK : */
sp_helpfilegroup

2 - To modify the msql_storage file :
Initial content :
*:*:T:group:011:5:
*:*:I:group:011:5:

After having added the relevant lines :
*:567:T:group:011:5:FILEGROUP fg567
*:567:I:group:011:5:FILEGROUP fg567
*:*:T:group:011:5:
*:*:I:group:011:5:

3 - To create table for company 567
Restart your Baan session, open GTM (ttaad4100) and create table tccom000
for the new 567 company.
Check that the newly created table is assigned to filegroup fg567 :
(Using Transc-SQL) :
dbcc checkfilegroup ('fg567')
This should display table ttccom000567
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
Audit file structure baan_user Tools Development 8 4th May 2007 15:32
How to print Postcript in landscape orientation heliopaixao Tools Administration & Installation 8 28th July 2006 14:39
seq.open berthe Miscellaneous 4 12th May 2005 11:20
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49


All times are GMT +2. The time now is 04:27.


©2001-2017 - Baanboard.com - Baanforums.com