?
Solved

MSSQLSYSTEMRESOURCE and DISTMDL DATABASE

Posted on 2010-01-11
1
Medium Priority
?
671 Views
Last Modified: 2012-05-08
Since I cannot see the MSSQLSYSTEMRESOURCE and DISTMDL DATABASES in SSMS and I need to move their .MDF and .LDF files form C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to D:\SQL\Data.
Will it be ok just to stop the instance,move the files to the new location and and change the path to D:\SQL\Data?
0
Comment
Question by:vera2006
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 26

Accepted Solution

by:
tigin44 earned 2000 total points
ID: 26283112
sure you can change the drive of the database files. One method is detach / attach and another method is using command

ALTER DATABASE dbName MOVE....

and after issuing the command stop the service move the files to noew location and start the sql service
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question