RE: Move the monitoring database
- From: Filmlover2002 <Filmlover2002@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 17 Apr 2007 04:40:01 -0700
""Crina Li"" wrote:
Hi Harner,.
Thank you for posting in SBS newsgroup.
I am sorry for the delayed response due to weekend. Please understand that
the newsgroups are staffed weekdays by Microsoft Support professionals to
answer your systems and applications questions. Your understanding is
greatly appreciated!
From the description, I understand the issue to be: you can not detach the
Monitoring instance database and receive the error. If I have misunderstood
your concerns, please do not hesitate to let me know.
You may need to first restart the service MSSQL$SBSMONITORING from
services.msc.
It may be that there is a connection made to the database due to the fact
that someone had opened say the Usage report page or something. Pausing an
instance of SQL Server just prevents new users from logging in; users who
are connected to the server are not disconnected and they can finish tasks.
When you are detaching a database, you need to make sure that all users -
including you - are out of the database. Instead of restarting the service,
you can also run the following command in the OSQL prompt to disconnect the
existing connections:
ALTER DATABASE <databasename> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Related information:
Moving Data Folders for Windows Small Business Server 2003
http://www.microsoft.com/downloads/details.aspx?FamilyID=A1D0AF69-1287-4225-
BD8B-59C89F44984B&displaylang=en
Hope this helps.
Please feel free to let me know if you have any questions or if you need
further assistance.
I'm looking forward to hearing from you.
Best regards,
Crina Li (MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: Move the monitoring database
|| From: =?Utf-8?B?SktIYXJuZXI=?= <JKHarner@xxxxxxxxxxxxxxxxxxxxxxxxx>
| Subject: Move the monitoring database
| Date: Sun, 26 Mar 2006 14:49:11 -0800
|| Newsgroups: microsoft.public.windows.server.sbs
||
| I am trying to move all datafiles off of the OS partition. I am following
the
| instructions given in "Moving Data Folders for Windows Small Business
Server
| 2003". In the "Move the Monitoring Database" section it tells you to:
|
| Verify that the Monitoring Instand of MSDE 2000 is running;
| Connect to the Monitoring instance of MSDE 2000 and detach the database.
|
| This is where I get stuck. I am able to complete the first task, and yes,
| the monitoring service is started. When I attempt to detach the database,
| (Osql -E -S SERVER\SBSMonitoring -Q "sp_detach_db 'SBSMonitoring'") I get
an
| error message stating "Cannot detach the database 'SBSMonitoring"
because it
| is currently in use."
|
| Any suggestions?
|
- Follow-Ups:
- RE: Move the monitoring database
- From: "Jacky Luo [MSFT]"
- RE: Move the monitoring database
- Prev by Date: Re: Publishing folders on companyweb
- Next by Date: RE: web server
- Previous by thread: Re: Windows Server 2003 SBS - Event ID 2020 Error
- Next by thread: RE: Move the monitoring database
- Index(es):
Relevant Pages
|
