RE: Move the monitoring database
- From: v-crinal@xxxxxxxxxxxxxxxxxxxx ("Crina Li")
- Date: Tue, 28 Mar 2006 01:59:00 GMT
Hi Jonathan,
Thanks for your update.
As I know, you can move them to the new location same with the
SBSMonitoring.mdf.
Thanks for your time and I look 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
| thread-index: AcZRvT1W0XQcxW5BQaC8j3MwOBA6Iw==
| X-WBNR-Posting-Host: 67.190.66.199
| From: =?Utf-8?B?SktIYXJuZXI=?= <JKHarner@xxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <2807FC16-E25A-435C-825B-23676D821FFE@xxxxxxxxxxxxx>
<BVLxjPWUGHA.4332@xxxxxxxxxxxxxxxxxxxxx>
| Subject: RE: Move the monitoring database
| Date: Mon, 27 Mar 2006 08:41:04 -0800
| Lines: 127
| Message-ID: <519DF209-3D30-41C6-A98D-FE1567685049@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
| Newsgroups: microsoft.public.windows.server.sbs
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:255939
| NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Thanks, Crina Li. That did the trick. One more thing:
|
| There were other .mdf and .ldf files in the SBSMonitoring folder besides
| SBSMonitoring.mdf and SBSMonitoring_log.ldf. While the "Moving Data
Folders
| for Windows Small Business Server 2003" document only specifies moving
the
| SBSMonitoring databases, can the others be moved as well?
|
| These files are:
|
| master.mdf
| mastlog.ldf
| model.mdf
| modellog.ldf
| tempdb.mdf
| templog.ldf
|
| I am trying to get all database files off of the C: drive and onto the D:
| drive.
|
| Thanks!
| Jonathan
|
| ""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?
| > |
| >
| >
|
.
- References:
- RE: Move the monitoring database
- From: "Crina Li"
- RE: Move the monitoring database
- From: JKHarner
- RE: Move the monitoring database
- Prev by Date: Re: A Partition Manager Question
- Next by Date: Re: Co-location or hosted SBS
- Previous by thread: RE: Move the monitoring database
- Next by thread: Error moving Exchange Database and Logs
- Index(es):
Relevant Pages
|
Loading
