BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/)
-   BES Admin Corner (http://www.blackberryforums.com/bes-admin-corner/)
-   -   Moving MSDE database files (http://www.blackberryforums.com/bes-admin-corner/204851-moving-msde-database-files.html)

mhawkins_family 09-21-2009 10:27 AM

Moving MSDE database files
 
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.

MarshBklyn 09-21-2009 10:41 AM

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

mhawkins_family 09-21-2009 03:08 PM

I followed a thread, number 62582.

hdawg 09-21-2009 06:54 PM

huh? post a screenshot of what you want to move to free up space.

mhawkins_family 09-22-2009 09:52 AM

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

MarshBklyn 09-22-2009 10:36 AM

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.

hdawg 09-22-2009 08:24 PM

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.

mhawkins_family 09-23-2009 09:14 AM

Thank you all for your help.


All times are GMT -5. The time now is 02:42 AM.

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.