BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-21-2009, 10:27 AM   #1 (permalink)
New Member
 
Join Date: Sep 2009
Location: Phoenix, AZ
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving MSDE database files

Please Login to Remove!

I have moved the BESMgmt files from one drive to another. I still see other files in the database folder and I would like to also move them to save space on my drive, but I do not see any mention of how to move the rest of them. Any help will be appreciated as I am fairly new with all of this.
Offline  
Old 09-21-2009, 10:41 AM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2009
Model: 9000
PIN: N/A
Carrier: crApT&T
Posts: 63
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

exactly how did you "move" your BESMgmt database files? cut and paste?
did you stop your BES services first? did you detach and attach?
There are a few methods to moving the BES database(s). Maybe this will help you:
How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance
Offline  
Old 09-21-2009, 03:08 PM   #3 (permalink)
New Member
 
Join Date: Sep 2009
Location: Phoenix, AZ
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I followed a thread, number 62582.
Offline  
Old 09-21-2009, 06:54 PM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

huh? post a screenshot of what you want to move to free up space.
Offline  
Old 09-22-2009, 09:52 AM   #5 (permalink)
New Member
 
Join Date: Sep 2009
Location: Phoenix, AZ
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Files I would like to move

These are the files that are still in the database that I would like to move them to the same location as the BESMgmt files that were moved, if possible.

Theye are currently in C:\Program Files\Microsoft SQL Server\MSSSQL\Data

master.mdf
mastlog.idf
mdss.idf
mdss.mdf
mdss_dis.ldf
mdss_dis.mdf
model.mdf
modellog.idf
msbdata.mdf
msdblog.idf
tempdb.mdf
templog.idf
Offline  
Old 09-22-2009, 10:36 AM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2009
Model: 9000
PIN: N/A
Carrier: crApT&T
Posts: 63
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

These files are not "in the database". These are sql database files that are in that directory. You will notice there is a data file and a log file (for transactions) for each of the databases. The master, model, msdb, and tempdb databases are sql installation specific and not related to BES. There are specific methods for moving/modifying these databases without causing ireperable damage to the sql installation. You can find that here:
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
There is much more detail to be said of these but this is not the forum for it.

As for the mdss and mdss_dis databases, if they are your BES databases and you would like to move them, you should stop your BES services, detach them (in sql), move the files (in windows), attach them (in sql), start your BES services again.
Offline  
Old 09-22-2009, 08:24 PM   #7 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

you can't move mdss and mdss_dis databases. You have to create new ones.

If you google on the other database names you'll learn you don't need to move them.
Offline  
Old 09-23-2009, 09:14 AM   #8 (permalink)
New Member
 
Join Date: Sep 2009
Location: Phoenix, AZ
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you all for your help.
Offline  
Closed Thread


Thread Tools

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.