BlackBerryForums.com : Your Number One BlackBerry Community      

»Sponsored Links




Closed Thread
 
LinkBack Thread Tools
  (#1 (permalink)) Old
Mikey_AGBoston Offline
New Member
 
Posts: 12
Join Date: Dec 2005
Model: 8830
Carrier: Verizon
Default BESMGMT database maintenance - 10-19-2006, 10:15 AM

All,
I am planning to move my BESMGMT.MDF and .LDF to a new drive
Prior to, I am wondering if there are OSQL commands which could be fired off
to ensure the health of these databases.

Does anyone use / know of any good practices for the validity and vitality of these MSDE databases?

FYI:
method of the above mentioned db move

osql -E
exec sp_detach_db @dbname = "BESMGMT”
go
quit



osql -E
EXEC sp_attach_db @dbname = "BESMGMT",
@filename1 = "F:\MSDE\BESMGMT.mdf",
@filename2 = "F:\MSDE\BESMGMT.ldf"
go
quit

Last edited by Mikey_AGBoston : 10-19-2006 at 10:18 AM.
   
Sponsored Links
Please Login or Register to Remove these Advertisements!

  (#2 (permalink)) Old
||||||| Offline
CrackBerry Addict
 
|||||||'s Avatar
 
Posts: 615
Join Date: Jun 2006
Model: 7100
Carrier: Rogers
Default 10-19-2006, 11:21 AM

Or do a backup/restore
   
  (#3 (permalink)) Old
x14 Offline
BlackBerry Extraordinaire
 
x14's Avatar
 
Posts: 1,766
Join Date: Jul 2005
Location: NYC
Model: 8800
Carrier: at&t
Default 10-19-2006, 12:31 PM

I did this a month ago. I detached the database, moved it, and re-attached it.
   
  (#4 (permalink)) Old
Mikey_AGBoston Offline
New Member
 
Posts: 12
Join Date: Dec 2005
Model: 8830
Carrier: Verizon
Default 10-19-2006, 12:34 PM

Any 'gotchas'?
Did you use my same steps as detailed in my post?
Any foresite would be appreciated.
   
  (#5 (permalink)) Old
x14 Offline
BlackBerry Extraordinaire
 
x14's Avatar
 
Posts: 1,766
Join Date: Jul 2005
Location: NYC
Model: 8800
Carrier: at&t
Default 10-19-2006, 12:38 PM

Quote:
Originally Posted by Mikey_AGBoston
Any 'gotchas'?
Did you use my same steps as detailed in my post?
Any foresite would be appreciated.
I did not do it from the command line. I did it using the Enterprise Manager.
   
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-2008 BlackBerryNews.com, BlackBerryFAQ.com, BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of Research In Motion Limited.
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.1